Jump to content


Photo

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


  • Please log in to reply
1 reply to this topic

#1 Hilly_2004

Hilly_2004
  • Members
  • PipPipPip
  • Advanced Member
  • 63 posts

Posted 12 March 2006 - 04:20 PM

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

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

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?



#2 Hilly_2004

Hilly_2004
  • Members
  • PipPipPip
  • Advanced Member
  • 63 posts

Posted 12 March 2006 - 09:45 PM

I would of thought it would be something like this:

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
But Im getting an error which says "Wrong arguments to MATCH".




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users