Another example is with LIKE operator if you do WHERE LIKE 'TEST%' explainer tells you will use index WHERE NOT LIKE 'TEST%' just scan table but you could end up in an example like that in the NOT LIKE statement gives you less result than the first
Another example is with LIKE operator if you do WHERE LIKE 'TEST%' explainer tells you will use index WHERE NOT LIKE 'TEST%' just scan table but you could end up in an example like that in the NOT LIKE statement gives you less result than the first