MySql的like語句中的萬用字元：百分比符號、底線和escape

標籤：blog   http   ar   使用   div   on   art   log   代碼   

MySql的like語句中的萬用字元：百分比符號、底線和escape%代表隨意多個字元Sql代碼 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%‘; _代表一個字元Sql代碼 select * from user where username like ‘_‘; select * from user where username like ‘huxia_‘; select * from user where username like ‘h_xiao‘; 假設我就真的要查%或者_，怎麼辦呢？使用escape，逸出字元後面的%或_就不作為萬用字元了，注意前面沒有逸出字元的%和_仍然起萬用字元作用Sql代碼 select username from gg_user where username like ‘%xiao/_%‘ escape ‘/‘; select username from gg_user where username like ‘%xiao/%%‘ escape ‘/‘;

MySql的like語句中的萬用字元：百分比符號、底線和escape