I'm having problems working with MATCH (a, b) AGAINST ('something')... my query is: SELECT name, MATCH (summary, description) AGAINST ('New York') AS relevant_num FROM people; I get the error message: ERROR 1191: Can't find FULLTEXT index matching the column list When I show index on the table in the database, I have the FULLTEXT indexes on the summary and description column, named "ftidx_summary" and "ftidx_description" respectively. So I tried: SELECT name, MATCH (ftidx_summary, ftidx_description) AGAINST ('New York') AS relevant_num FROM people; Which obviously didn't work. Anyway, I've RTFM manual and it's unclear about how you implement the syntax. Any help, guidance, etc. would be greatly appreciated. Thanks. -- Clarence -> [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php