模糊查询like的用法(国外英语资料).docVIP

模糊查询like的用法(国外英语资料) Fuzzy query is the use of like: this is the following SQL for special character processing methods in like operations: In SQL Server queries, single quotes are special characters, so turn them into double single quotes when you query. In like the operation and the following special characters: underscore characters, percent %, square brackets [], pointed ^. Its USES are as follows: Underscore: for an arbitrary character (equivalent to a regular expression?) Percentage: to replace any number of arbitrary characters (equivalent to the * in regular expressions) Square brackets: used for escaping (in fact, only the left square brackets are used for escaping, and the right square bracket USES the latest priority principle to match the recent left square brackets) Tip: to exclude some characters to match (this is the same as in regular expressions) Here are some examples of matches that need to be explained that only the like operation has these special characters, = no action. A_b... A [_] b % A % b... A [%] b % A [b] A] b... A] % b A [] b... A [[]] b % (^) b... A [[] [^]] % b A [^ ^) b... A [[] [^] [^]] % b In the case of actual processing, for = operations, we usually only need to replace this: - For the like operation, the following replacement needs to be done (note the order is also important) [- [[] (this must be the first one!!) % - (%) (this % is the % of the characters that wish to match, but not the wildcard that is specifically used for matching) - [_] ^ - (^) 3 SQL Like wildcard usage: Escape Explain the role of Escape: Use the ESCAPE keyword to define ESCAPE characters. In the schema, the wildcard is interpreted as a normal character when the escape character is placed before the wildcard. For example, to search for a string that contains 5 percent of a string in any location, use: WHERE ColumnA LIKE % % ESCAPE/ But it seems like you cant use \ in mysql. ESCAPE escape_character Allow searching for wildcards in strings instead of using