sql中like的多种用法（Multiple uses of like in SQL）.doc

sql中like的多种用法（Multiple uses of like in SQL） Using the fuzzy query instruction LIKE in SQL Server Time: 2010-04-12 13:48, source: home of network management, integrated font: [large, medium, small] The query is an important function of SQL Server, and Like in the query will use, you can search some unexpected results and effects, the magic of like is that it offers the fuzzy query function, through four kinds of wildcard match with it, like play an important role in the condition. First, use Like in general search criteria The data types that can be paired with LIKE are strings, dates, or time values. The LIKE keyword can use regular expressions that contain the above three types of data, which contain any combination of the following four wildcards. Wildcard meaning Any string containing zero or more characters. _ (underlined) any single character. [] any single character within a specified range (e.g., [a-f]) or set (e.g., [abcdef]). [^] is not in the specified range (e.g. [^a f]) or set (e.g. [^abcdef]) within any single character. Please include wildcards and strings in single quotation marks, for example: LIKE will search the surname Zhao % names or to Chinese characters at the beginning of the string Zhao (Zhao Gang, Zhao Xiaogang). LIKE will just search in all Chinese characters just at the end of the string (such as Liu Gang, Li Xiaogang, etc.). LIKE will search for small%. All the string contains Chinese characters of small in any position (such as Zhao Xiaogang, Li Xiaogang, Yamamoto Lang). LIKE_ Xiaogang will search for names of all three Chinese characters end in Chinese characters Gang (Li Xiaogang, Zhao Xiaogang). For English, more cases, such as LIKE[CK]ars[eo]nsearches for the following strings: Carsen, Karsen, Carson, and Karson (such as Carson). LIKE[M-Z]ingersearches for all names at the end of the string inger, beginning with any single letter from M to Z (such as Ringer). LIKEM[^c]%starts the search with the letter M, and the second letter is not