Common situations of mysql index failure

Collection Like

PHP Chinese website brings to you common situations in which mysql indexes fail: 1. Using functions or operations; 2. Implicit type conversion; 3. Using not equal to (!= or <>); 4. Using the LIKE operator, and Starting with a wildcard; 5. OR condition; 6. NULL value; 7. Low index selectivity, etc.