List:General Discussion« Previous MessageNext Message »
From:Moz Date:October 5 1999 9:39pm
Subject:A question about indexes
View as plain text  
Hello everybody

I've just a question:

i've created a Table with an index for exemple:

CREATE  TABLE test (id not null int, tes text,key(id));

I've also read that MySQL don't use indexes when you use LIKE argument
and the string starts with a wild char.
But if I write the follow command:

SELECT * FROM test WHERE id=1 AND tes LIKE '%kdkds%'

Does the index work in this case ?






Thread
A question about indexesMoz5 Oct
  • Re: A question about indexesBob Kline5 Oct
    • Outputting Selects in Random OrderHunter Hillegas5 Oct
      • Re: Outputting Selects in Random OrderThimble Smith6 Oct
      • Re: Outputting Selects in Random OrderBob Kline6 Oct
        • Re: Outputting Selects in Random OrderScott Hess6 Oct
          • Re: Outputting Selects in Random OrderThimble Smith6 Oct
          • Re: Outputting Selects in Random OrderBob Kline6 Oct
            • Re: Outputting Selects in Random OrderHunter Hillegas6 Oct
              • Re: Outputting Selects in Random OrderBob Kline6 Oct
                • Re: Outputting Selects in Random OrderMartin Ramsch7 Oct
    • Re: Outputting Selects in Random OrderHunter Hillegas6 Oct
Re: A question about indexesMark Papadakis5 Oct
  • Re: A question about indexesBob Kline6 Oct