SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Feb 2011
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    FULLTEXT search problem

    Hi Guys;
    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

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,270
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    to start with, storing a comma-delimited list in a single column value is going to give you a ~lot~ of headaches

    i don't really understand what you're trying to match, though

    the entire title against all keywords? only one keyword? does each keyword have to be included in the title?

    in any case i'm going to guess that FULLTEXT is not what you want here
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •