Re: A question about indexes

[Mark Papadakis]

Hi!

No, it won't work.
a select * from table where column like 'data%'
would use the index if properly indexed.

MarkP

Moz wrote:
>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 ?
>
>
>
>
>
>
>
>---------------------------------------------------------------------
>Please check
>"http://www.mysql.com/Manual_chapter/manual_toc.html"
>before
>posting. To request this thread, e-mail
>mysql-thread15219@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@stripped instead.
>