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

Wildcard characters in the like statement for MySQL: percent, underscore, and escape%: denotes any or more characters. Can match any type and length of characters.     SQL code SELECT * from user where username like '%huxiao ';     SELECT * from user where username like ' huxiao% '; SELECT * from user where username like '%huxiao% ';

Also, if you need to find a record of "three" and "cat" in U_name, use the and condition

SELECT * FROM [user] WHERE u_name like '% three ' and u_name like '% cat% '

If using SELECT * from [user] WHERE u_name like '% cat% '

Although can search out "three feet cat", but can not search out the eligible "Zhang Cat three".

_: Represents any single character. Matches a single arbitrary character, which is commonly used to restrict the expression's character-length statement: (which can represent one Chinese character)

SQL code SELECT * from user where username like ' _ ';     SELECT * from user where username like ' Huxia_ ';     SELECT * from user where username like ' H_xiao '; If I really want to check% or _, how to do? Use escape, the escape character after the% or _ is not used as a wildcard, note that there is no escape character before the% and _ still play wildcard function SQL code Select Username from Gg_user where username like '%xiao/_% '     Escape '/'; Select username from Gg_user where username like '%xiao/%% ' escape '/';

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