[PHP-DB] Question about undices for inversed LIKE statesments.

2004-05-31 Thread Alexey Kupershtokh
Hello. I have a question about behaviour of indices in queries with inversed LIKE in MySQL. I mean something like this: select foo from bar where '$some_string' LIKE some_field where in the `some_field` I have a strings like 'symbols%' :) Do you have some ideas? WBR, Wicked -- PHP Database

Re: [PHP-DB] Question about undices for inversed LIKE statesments.

2004-05-31 Thread Daniel Clark
The index should still work normally. Hello. I have a question about behaviour of indices in queries with inversed LIKE in MySQL. I mean something like this: select foo from bar where '$some_string' LIKE some_field where in the `some_field` I have a strings like 'symbols%' :) Do you have some