Hi,
Why does this not work?
SELECT * FROM News WHERE category='sport' AND MATCH
(subcategory,headline,summary) AGAINST ('madrid') LIMIT 1,25
If i remove the "category='sport' AND" from the WHERE clause it works - yet all
documents in the db currently have category='sport'. Is it not possible to mix
a MATCH with another condition?
Any ideas, or is the only solution to run the first query, store the results in
a temp table, and then run a 2nd query.
Regards
Martin Curmi
---------------------------------------------------------------------
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
