| 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 indexes | Moz | 5 Oct |
| • Re: A question about indexes | Bob Kline | 5 Oct |
| • Outputting Selects in Random Order | Hunter Hillegas | 5 Oct |
| • Re: Outputting Selects in Random Order | Thimble Smith | 6 Oct |
| • Re: Outputting Selects in Random Order | Bob Kline | 6 Oct |
| • Re: Outputting Selects in Random Order | Scott Hess | 6 Oct |
| • Re: Outputting Selects in Random Order | Thimble Smith | 6 Oct |
| • Re: Outputting Selects in Random Order | Bob Kline | 6 Oct |
| • Re: Outputting Selects in Random Order | Hunter Hillegas | 6 Oct |
| • Re: Outputting Selects in Random Order | Bob Kline | 6 Oct |
| • Re: Outputting Selects in Random Order | Martin Ramsch | 7 Oct |
| • Re: Outputting Selects in Random Order | Hunter Hillegas | 6 Oct |
| • Re: A question about indexes | Mark Papadakis | 5 Oct |
| • Re: A question about indexes | Bob Kline | 6 Oct |
