程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> SqlServer數據庫 >> 關於SqlServer >> SQL Server中的模式匹配

SQL Server中的模式匹配

編輯:關於SqlServer
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%'

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved