A like fuzzy query in MySQL

Wildcard characters in the like statement for MySQL: percent, underline, and escape

% represents any number of characters_ represents a characterEscape , which escapes the character after the% or _, so that it does not act as a wildcard, but a normal character matchThe database data is as follows:

1. Find the field in the name named Lucy

Query statement:

SELECT * from ' user ' where name like ' lucy% '

Results:

2. Query the field whose name is "Lucy" and is followed by only one character

Query statement:

SELECT * from ' user ' where name like ' Lucy_ '

Query Result:

3. Find fields starting with "Lucy_" in the name

Query statement:

SELECT * from ' user ' where name like ' lucy/_% ' escape '/'

Query Result:

4, the query name with "Lucy" beginning, the middle contains "_", "2" end of the field

Query statement:

SELECT * from ' user ' where name like ' lucy%/_%2 ' ESCAPE '/'

Query Result:

A like fuzzy query in MySQL