Re: Full Text search on multiple tables?

[xingliang cai]

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.