Wildcards in the like Statement of MySql: percent, underline, and escape

Wildcard characters: percent, underline, and escape % in the like Statement of MySql indicate any number of characters in the SQL code www.2cto.com select * from user where username like '% huxiao '; select * from user where username like 'huxiao % '; select * from user where username like' % huxiao % '; _ indicates a single character SQL code select * from user where username like '_'; select * from user where username like 'huxia _'; select * from user where username like 'H _ xiao '; what if I want to check % or? If you use escape, the % or _ following the escape character is not used as a wildcard, note that the % and _ characters without escape characters are still used as wildcards. SQL code select username from gg_user where username like '% xiao/_ % 'escape '/'; select username from gg_user where username like '% xiao/%' escape '/';