MATCH AGAINST two tables
Posted: Sun May 04, 2008 7:33 am
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 :
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')