《Mysql必讀sql like語(yǔ)句通配符百分號(hào)、下劃線與escape用法》要點(diǎn)：
本文介紹了Mysql必讀sql like語(yǔ)句通配符百分號(hào)、下劃線與escape用法，希望對(duì)您有用。如果有疑問(wèn)，可以聯(lián)系我們。
導(dǎo)讀：在sql查詢中,像*和?,sql的like語(yǔ)句中,使用%和_來(lái)代表任意多個(gè)字符和一個(gè)字符
# %代表任意多個(gè)字符 select * from user where us...
MYSQL學(xué)習(xí)在sql查詢中,像*和?,sql的like語(yǔ)句中,使用%和_來(lái)代表任意多個(gè)字符和一個(gè)字符
?
# %代表任意多個(gè)字符?
select * from user where username like '%huxiao';?
select * from user where username like 'huxiao%';?
select * from user where username like '%huxiao%';?
?
# %代表一個(gè)字符?
select * from user where username like '_';
select * from user where username like '______';
select * from user where username like 'huxia_';
select * from user where username like 'h_xiao';?
?
# 要查%或者_(dá),的話?使用escape,轉(zhuǎn)義字符后面的%或_就不作為通配符了,注意前面沒(méi)有轉(zhuǎn)義字符的%和_仍然起通配符作用?
select username from gg_user where username like '%xiao/_%' escape '/';?
select username from gg_user where username like '%xiao/%%' escape '/';?
轉(zhuǎn)載請(qǐng)注明本頁(yè)網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/6478.html
