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