Results 1 to 2 of 2
Thread: FULLTEXT search problem
Feb 5, 2011, 22:35 #1
- Join Date
- Feb 2011
- 0 Post(s)
- 0 Thread(s)
FULLTEXT search problem
I am new in mysql and have not that much of knowledge about the sql language. I am trying to join 2 tables so I can compare that title field in table resources with keywords filed in table categories and this is what I wrote but no matter how I can not get it to work.
SELECT * FROM rss_articles JOIN rss_categories
(MATCH (rss_articles.title) AGAINST (rss_categories.keywords IN BOOLEAN MODE)
Would you please tell me where am I going wrong? The keywords are comma seperated in the rss_categories.keywords field.
Thanks a lot for the help