I am trying to get this select command to use and index file - when I run explain i get a null value for the chosen key
Ihave been tryng alsorts regexp <>
this is the expression
Select * from categories where id != 'cfcd208495d565ef66e7dff9f98764da' and parent_id = 'cfcd208495d565ef66e7dff9f98764da' and showcategory = 'Y' order by categoryname
if i change the != to = the index is selected fine
can any one help or offer any suggestion.
Ihave been tryng alsorts regexp <>
this is the expression
Select * from categories where id != 'cfcd208495d565ef66e7dff9f98764da' and parent_id = 'cfcd208495d565ef66e7dff9f98764da' and showcategory = 'Y' order by categoryname
if i change the != to = the index is selected fine
can any one help or offer any suggestion.