SQL Server中的模式匹配


SQL Server Books Online上面搜索like,找到了包含%,_,[],[^]几个通配符。
如:select * from mybbs where Content like '[w]%'
like关键字用于搜索匹配某个模式的字符串,或者日期,时间值。


SQL Server Books中的部分解释如下:

Pattern Matching in Search Conditions
The LIKE keyword uses a regular expression to contain the pattern that the values are matched against. The pattern contains the character string to search for, which can contain any combination of four wildcards.

Wildcard Meaning % Any string of zero or more characters. _ Any single character. [ ] Any single character within the specified range (for example, [a-f]) or set (for example, [abcdef]). [^] Any single character not within the specified range (for example, [^a - f]) or set (for example, [^abcdef]).

Enclose the wildcard(s) and the character string in single quotation marks, for example:

LIKE '%en%' searches for all strings that contain the letters en anywhere in the string (Bennet, Green, McBadden).

LIKE '_heryl' searches for all six-letter names ending with the letters heryl (Cheryl, Sheryl).

LIKE '[CK]ars[eo]n' searches for Carsen, Karsen, Carson, and Karson (Carson).

LIKE '[M-Z]inger' searches for all names ending with the letters inger that begin with any single letter from M through Z (Ringer).

LIKE 'M[^c]%' searches for all names beginning with the letter M that do not have the letter c as the second letter (MacFeather).
This query finds all phone numbers in the authors table that have area code 415:

SELECT phone

FROM pubs.dbo.authors

WHERE phone LIKE '415%'

本文作者:



相关阅读:
Javascript select控件操作大全(新增、修改、删除、选中、清空、判断存在等)
asp.net 在DNN模块开发中遇到的resx怪问题
JavaScript 工具库 Cloudgamer JavaScript Library v0.1 发布
用mysql触发器自动更新memcache的实现代码
vb.net入门——PictureBox控件的使用
用Javascript进行简单的Table点击排序
you *might* want to use the less safe log_bin_trust_function_creators variable
特效窗口一网打尽
一个连接两个不同MYSQL数据库的PHP程序
网页制作掌握的最常用的HTML标记
Ubuntu中安装与卸载KDE桌面方法
Dell 1200笔记本安装WinXP时盘符错乱
用vbscript实现隐藏任务栏图标的脚本
PHP框架之Qcodo
快速导航

Copyright © 2016 phpStudy |