模糊查询(只能用在数据类型为字符串的字段上)
_代表任意一个字符 %代表任意多个字符
查询姓名由6个字母组成
SELECT * FROM login_users WHERE username LIKE '______'
查询六个字母组成并且第六个为i
SELECT * FROM login_users WHERE username LIKE '_____i'
姓名以z开头
SELECT * FROM login_users WHERE username LIKE 'z%'
姓名第二个字母为i
SELECT * FROM login_users WHERE username LIKE '_i%'
姓名中包含a
SELECT * FROM login_users WHERE username LIKE '%a%'