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%'
