模糊查询like的用法（The use of like fuzzy query）.docVIP

模糊查询like的用法（The use of like fuzzy query） Fuzzy query like usage: as follows SQL of like special character processing method in operation: SQL Server in the inquiry process, is a special character, so when the query to be converted into single quotes. The like operation has the following special characters: underline _,%, brackets, tip number. The purposes are as follows: Underline: used instead of an arbitrary character (equivalent to the regular expression?) Sign: used to replace any number of arbitrary characters (equivalent to the regular expression in the * * * *) Square brackets: used to escape (in fact only the left bracket used to escape, right bracket using the priority principle, the nearest recently left bracket) Tip number: used to exclude some characters matching (like this in a regular expression) The following are some, for example, that is, only like have some special characters, there is no = operation. A_b... A[_]b% A%b... A[%]b% A[b... A[[]b% A]b... A]b% A[]b... A[[]]b% A[^]b... A[[][^]]b% A[^^]b... A[[][^][^]]b% In actual processing, for = operation, we generally only need such replacement: - For like operation, the need for the following replacement (note that the order is important) [- [[] (this must be the first replacement!!) % - [%] (% here refers to the hope matching character itself includes% rather than for matching wildcards) _ - [_] ^ - [^] 3.SQL Like: Escape special use wildcards On the role of Escape: The 1. is defined using the ESCAPE keyword escape character. In the model, when the escape character in the wildcard wildcard, it is interpreted as an ordinary character. For example, the search string contains 5% string at any position, please use the: WHERE ColumnA LIKE%5/%%ESCAPE But MySQL cant seem to use \ . 2.ESCAPEescape_character Allow the search string in the wildcard rather than its use as a wildcard. The escape_character is placed in the wildcard character said the special character. * SELECT FROM finances WHERE descriptio