精确查询
精确字段全部
SELECT * FROM chglist WHERE name LIKE 'hexingxing'
模糊查询
使用'%%'
来判断
1. %% 前后都可模糊
SELECT * FROM chglist WHERE name LIKE '%hexingxing%'
2: _ 是任意单个字符的意思
SELECT * FROM chglist WHERE name LIKE '%_hexingxing%'
SELECT * FROM chglist WHERE name LIKE '%_hexingxing_%'
SELECT * FROM chglist WHERE name LIKE '%hexingxing_%'
3. [ ] 表示括号内所列字符中的一个:匹配 1hexingxing 2hexingxing 3hexingxing 开头的数字
SELECT * FROM chglist WHERE name LIKE '%[123]hexingxing%'
4. [^ ] 表示除了括号内所列字符中之外,与第 3 个相反
SELECT * FROM chglist WHERE name LIKE '%[^123]hexingxing%'
0 条评论