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

Tagged with: MySQL like escape percent semicolon wildcard

Wildcard characters in the like statement for MySQL: percent, underscore, and escape% represent any number of characters in SQL code Http://blog.csdn.net/yc7369/select * from user where username like '% Huxiao '; SELECT * from user where username like ' huxiao% '; SELECT * from user where username like '%huxiao% '; _ Represents a character SQL code select * from the 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 '/';