SQL Server中的模式匹配
2024-08-31 00:48:06
供稿:網友
 
 
author: david euler
date: 2004/11/17
email: [email protected] 
有任何問題,請與我聯系:)
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.
wildcardmeaning%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 phonefrom pubs.dbo.authorswhere phone like '415%'