select * from myTable where myInt
will not show any possible_keys when explaining the query even though there is an index on myInt field.
Edit:
The index in question is not unique.
For MySQL to use the index, you have to explicitly compare the int field to a value (e.g. true, 1).
select * from myTable where myInt = true
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With