Hi,
with a table with 33 rows, i have the row in 0s using index on term.
mysql> select * from tx where term like 'Britney Spears' ;
+++
| id | term |
+++
| 327681 | Britney Spears |
+++
1 row in set (0.00 sec
What is the output of the following:
EXPLAIN select * from terms where term like 'Britney Spears' limit 1;
select_type = SIMPLE
table = terms
type = range
possible_keys = term, term_2 (I just created term_2, fulltext)
key = term (this means it's not using the one I just created?)
key_len = 255
ref
Brian,
What is the output of the following:
EXPLAIN select * from terms where term like 'Britney Spears' limit 1;
Running this statement will produce info on what index path is being used in
the query. Also, can you use "=" instead of "like" in your query?
Partha
--
Partha Dutta, Senior Consul