MySQL Forums
Forum List  »  Full-Text Search

Re: Structural and Conceptual dillemma with multiple word FTSearch on multiple tables
Posted by: Rick James
Date: April 05, 2010 07:55AM

Give this a try:
SELECT man_id
   FROM
      ( SELECT man_id FROM Manufacturer WHERE MATCH(name) AGAINST('+Apple') ) m
   JOIN
      ( SELECT man_id FROM Products WHERE MATCH(name) AGAINST('+Idud') ) p
   ON m.man_id = p.man_id;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Structural and Conceptual dillemma with multiple word FTSearch on multiple tables
2106
April 05, 2010 07:55AM


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.