Re: Query the Index?

[Rick James]

Sure...
CREATE TABLE foo (..., word VARCHAR(33) ..., INDEX(word), ...);
SELECT word FROM foo WHERE word LIKE 'b%';
will reference only the index.

To confirm that, do EXPLAIN; notice that it will say "Using index". This means that it can execute the SELECT entirely from the index.

And, if you want the work done for you, consider
https://developer.yahoo.com/yui/autocomplete/



Edited 1 time(s). Last edit at 10/21/2010 09:09AM by Rick James.