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;