MySQL Forums
Forum List  »  Full-Text Search

Re: Full Text search on multiple tables?
Posted by: xingliang cai
Date: November 06, 2006 11:27PM

I think it won't be possible to do multiple table search as the algorithm for full text search is to index all the words present in one or serveral columns first, and assign weightage to each word and them perform search on any specific word. To be able to do a full text search, thus you must get the coulumns first and create a index first. Thus to search several columns in multiple table, you got to join those columns first, create a full text index on those columns and then you can perform any search.

Try to create a full text index on the columns you are interested first. Since those columns are in different tables, unless mysql support full text index on mulitple tables, you can not perform the search in multiple tables accordingly.

Options: ReplyQuote

Written By
January 05, 2006 06:23PM
Re: Full Text search on multiple tables?
November 06, 2006 11:27PM

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.