Introduction to four usage of fuzzy query in mysql

The following describes the usage of fuzzy search in mysql:

1, %: represents any 0 or multiple characters. It can match any type and length of characters. In some cases, if it is Chinese, use two percent signs (%.
For example, SELECT * FROM [user] WHERE u_name LIKE '% 3%'
We will find all records with "3", such as "3 Zhang", "3 Zhang", "3 Zhang Mao", and "3 Tang sanzang.
In addition, if you need to find records with "three" and "cat" in u_name, use the and condition.
SELECT * FROM [user] WHERE u_name LIKE '% 3%' AND u_name LIKE '% cat %'
If SELECT * FROM [user] WHERE u_name LIKE '% 3% cat %' is used'

Although three-legged cats can be searched, three-legged cats cannot be searched ".

2, _: represents any single character. Matches any character. It is often used to limit the character length of an expression:
For example, SELECT * FROM [user] WHERE u_name LIKE '_ 3 _'
Only find that the u_name such as "Tang sanzang" is three characters and the middle word is "three;

For example, SELECT * FROM [user] WHERE u_name LIKE 'three _ '; only the three-legged cat is found. The name is three characters and the first word is "three;

3, []: represents one of the characters listed in brackets (similar to a regular expression ). Specifies a character, string, or range. The matching object must be one of them.
For example, SELECT * FROM [user] WHERE u_name LIKE '[Zhang Li Wang] san' will find "Zhang San", "Li San", and "Wang San" (rather than "Zhang Li Wang San ");
For example, if [] contains a series of characters (01234, abcde, etc.), it can be slightly written as "0-4" or "a-e"
SELECT * FROM [user] WHERE u_name LIKE 'Old [1-9] 'will find "Old 1", "old 2 ",...... , "Old 9 ";

4, [^]: represents a single character not listed in parentheses. The value is the same as [], but it requires that the matched object be any character other than the specified character.
For example, SELECT * FROM [user] WHERE u_name LIKE '[^ Zhang Li Wang] san' will find "Zhao San" without the surname "Zhang", "Li", and "Wang ", sun San and others;
SELECT * FROM [user] WHERE u_name LIKE 'Old [^ 1-4] '; will exclude "Old 1" to "old 4 ", search for "old 5", "old 6 ",......

5. When the query content contains wildcards
The special characters "%", "_", and "[" cannot be properly queried due to wildcards, when special characters are included in "[]", they can be queried normally. Then, write the following functions:
Function sqlencode (str) str = replace (str ,"';","';';")
Str = replace (str, "[", "[[]") '; this sentence must be in the first str = replace (str, "_", "[_]") str = replace (str, "%", "[%]") sqlencode = str end function