Jump to content

Archived

This topic is now archived and is closed to further replies.

Hilly_2004

Is it possible to Full Text Search 2 Tables at the same time?

Recommended Posts

Ive got this Full Text Search Select query which works perfectly....

[code]
SELECT Submissions.Submission_ID
     , Submissions.Conference_ID
     , Submissions.Subject_ID
     , Submissions.Title
     , Submissions.Summary
     , Submissions.Keywords
     , Submissions.Timestamp
     , forum_members.M_FIRSTNAME
     , forum_members.M_SURNAME
     , forum_members.M_NAME
     , forum_members.MEMBER_ID
     , MATCH(Submissions.Title
           , Submissions.Summary
           , Submissions.Keywords)
           AGAINST ('$searchstring') AS score
  FROM Submissions
LEFT
  JOIN forum_members
    on Submissions.MEMBER_ID
     = forum_members.MEMBER_ID
WHERE Submissions.Conference_ID = $CurrentConfID
   AND MATCH(Submissions.Title
           , Submissions.Summary
           , Submissions.Keywords)
           AGAINST ('$searchstring') > 0
ORDER
    BY score DESC
[/code]

It will search the columns title, summary and keywords in a table called Submissions, however at the same time could I search the columns M_FIRSTNAME, M_SURNAME and M_NAME from a table called forum_members?

Share this post


Link to post
Share on other sites
I would of thought it would be something like this:

[code]
SELECT Submissions.Submission_ID
     , Submissions.Conference_ID
     , Submissions.Subject_ID
     , Submissions.Title
     , Submissions.Summary
     , Submissions.Keywords
     , Submissions.Timestamp
     , forum_members.M_FIRSTNAME
     , forum_members.M_SURNAME
     , forum_members.M_NAME
     , forum_members.MEMBER_ID
     , MATCH(Submissions.Title
           , Submissions.Summary
           , Submissions.Keywords)
           AGAINST ('$searchstring') AS score
  FROM Submissions
LEFT
  JOIN forum_members
    on Submissions.MEMBER_ID
     = forum_members.MEMBER_ID
WHERE Submissions.Conference_ID = $CurrentConfID
   AND MATCH(Submissions.Title
           , Submissions.Summary
           , Submissions.Keywords
           , forum_members.M_FIRSTNAME
           , forum_members.M_SURNAME
              , forum_members.M_NAME
           , forum_members.MEMBER_ID )
           AGAINST ('$searchstring') > 0
ORDER
    BY score DESC
[/code]
But Im getting an error which says "Wrong arguments to MATCH".

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.