MySQL Forums
Forum List  »  Full-Text Search

Advanced Search
New Topic

Re: Full-Text Search on different tables (with joins)
Posted by: Rick James
Date: August 09, 2012 11:55PM

Use UNION instead of OR.

That is, formulate a query for each MATCH, then UNION the SELECTs together.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Full-Text Search on different tables (with joins)
7735
Dominik Meyer
August 05, 2012 08:44AM
Re: Full-Text Search on different tables (with joins)
2863
Rick James
August 09, 2012 11:55PM


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.