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 = NULL Extra = Using where
Also, can you use "=" instead of "like" in your query?
Yes, I made that change and it still works, so I'll leave it.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
