Sorry, I figured it out... I need to create a FULLTEXT index on the
columns I want to search, then I have the "match" those columns in the
query.
:-)
----------------------------------------------------------------------------
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
