mysql like 通配符
****************************
like 通配符
_ :匹配单个字符
%:匹配0到多个字符
示例
select "hello world" like "%"; //输出1
select "hello world" like "%"; //输出1
select "a" like "_"; //输出1
select "ab" like "__"; //输出1
select "a" like "[ab]"; //输出0,like表达式不能识别字符集
select "a" regexp "[ab]"; //输出1
select "adsdad" like "ds"; //输出0
select "adsdad" like "%ds%"; //输出1
select "adsdad" regexp "ds"; //输出1
说明:like表达式中不能识别字符集,要在正则表达式中使用