Has any one come accross this one.
I have a 32 character field that is indexes
Explain Select * from categories where parent_id = 'cfcd208495d565ef66e7dff9f98764da'
This is md5 0 (zero)
Does not select the index
delete one of the characters any one from the string and the correct index is selected - i have tried lengthening the filed but does not make any differnence
The query runs fine
I have a 32 character field that is indexes
Explain Select * from categories where parent_id = 'cfcd208495d565ef66e7dff9f98764da'
This is md5 0 (zero)
Does not select the index
delete one of the characters any one from the string and the correct index is selected - i have tried lengthening the filed but does not make any differnence
The query runs fine