Skip navigation links

MySQL Forums :: Full-Text Search :: FULL-TEXT SEARCH over Two Tables with JOIN?


Advanced Search

Re: FULL-TEXT SEARCH over Two Tables with JOIN?
Posted by: Rick James ()
Date: August 07, 2011 11:16PM

Since this is the FULLTEXT forum, use FULLTEXT syntax:
SELECT  a.artist, t.title, t.episode
    FROM  tracks AS t
    INNER JOIN  artist AS a ON a.id = t.artist
    WHERE  MATCH(a.artist) AGAINST ('+Spears' IN BOOLEAN MODE)
      AND  MATCH(t.title) AGAINST ('+World' IN BOOLEAN MODE);
Does that do what you want?

Options: ReplyQuote


Subject Views Written By Posted
FULL-TEXT SEARCH over Two Tables with JOIN? 5612 Johan Ekström 07/29/2011 06:54AM
Re: FULL-TEXT SEARCH over Two Tables with JOIN? 2081 Rick James 08/07/2011 12:33PM
Re: FULL-TEXT SEARCH over Two Tables with JOIN? 1826 Johan Ekström 08/07/2011 04:27PM
Re: FULL-TEXT SEARCH over Two Tables with JOIN? 1897 Rick James 08/07/2011 11:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.