Mysql精确查询与模糊查询

精确查询

精确字段全部

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%'