mysql第八章用通配符进行过滤

(1)select user, last_name from users where user like 'ad%';
#匹配ad开头的数据，字数无限制

(2) select user, last_name from users where user like '%or%';
 #匹配中间字符是or的数据

(3)select user, last_name from users where user like 's%y';
#匹配s开头y结尾的字符，中间字符无限制

(4)select user, last_name from users where user like '_mithy';
#_通配符只能匹配一个字符，匹配结尾是mithy的数据