MySQL Forums
Forum List  »  Full-Text Search

Structural and Conceptual dillemma with multiple word FTSearch on multiple tables
Posted by: Jarrett Lenox
Date: March 28, 2010 07:37PM

I having trouble understanding how multiple word searches are done with FULLTEXT on multiple joined tables.
Example:
I want to search for "Apple Idud".
*Manufacturer, Apple, is stored in one table with id, man_name, man_desc.
*Item, Idud, is stored in another table with id, item_name, man_id (manufacturer id), item desc.

I know how to "explode" the search string and MATCH AGAINST a single word and a single table in multiple queries, but what I can't conceptualize is how to have a query join the two tables and search for "apple"+"idud" as the most relevant result.
I know the wizards on this forum can do this in their sleep.

Please Help, I'm a total Newb.

Options: ReplyQuote


Subject
Views
Written By
Posted
Structural and Conceptual dillemma with multiple word FTSearch on multiple tables
4047
March 28, 2010 07:37PM


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.