测试必备的Mysql常用sql语句系列
https://www.cnblogs.com/poloyy/category/1683347.html
LIKE '字符串'
NOT LIKE '字符串'
%
%
a%b
select * from yyTest where username like "%test%";
select * from yyTest where username not like "test%" and department = "seewo";
匹配的字符串必须加单引号或双引号 like "%test%"
_
a_b
select * from yyTest where username like "test_";
like "test1"
binary
select * from yyTest where username like binary "TEST_";
\
select * from yyTest where username like "%\%"
" test% "