Page 1 of 1

MATCH AGAINST two tables

Posted: Sun May 04, 2008 7:33 am
by kendall
Hello guys,

If I had two or more tables with FULL TEXT Search Indexes on them can I perform a MATCH AGAINST where MATCH is a combination of ALL columns existing in the FULL TEXT Search Indexes of all tables?

thus :

Code: Select all

table1 - FULL TEXT - cola,colb
table2 - FULL TEXT - col1,col2,col3,col4

SELECT * WHERE MATCH(cola,colb,col1,col2,col3,col4) AGAINST('term')