MySQL Forums
Forum List  »  InnoDB

Is FULLTEXT search possible after joining multiple tables?
Posted by: Manos
Date: October 11, 2006 08:10PM

Hello,

I have Customer information split in more than one tables, i.e. 1 table holds the Customer name, another table holds the customer addresses (as one Customer can have more than one address) and other tables holding phone numbers, and employees details.

My question is: can I join the tables and then perform a full text search? If yes, shall I first add a FULLTEXT index to all the tables included in the query?

May your queries run faster if you know the answer!
Manos._

Options: ReplyQuote


Subject
Views
Written By
Posted
Is FULLTEXT search possible after joining multiple tables?
2121
October 11, 2006 08:10PM


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.