MySQL索引失效的部分情况

MySQL索引失效的部分情况（学习笔记）

1.涉及到计算

SELECT * FROM user WHERE age - 1>18;

2. 前置通配符

SELECT * FROM user WHERE name LIKE '%xiao%';

下面这样写索引可能不会失效

SELECT * FROM user WHERE name LIKE 'xiao%';

3.使用！=或者IS NOT NULL

SELECT * FROM user WHERE age != 18;

SELECT * FROM user WHERE hobby IS NOT NULL;