MATCH AGAINST two tables

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
kendall
Forum Regular
Posts: 852
Joined: Tue Jul 30, 2002 10:21 am
Location: Trinidad, West Indies
Contact:

MATCH AGAINST two tables

Post 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')

Post Reply