2 or more tables with FULLTEXT index

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Hi everybody, I need some help. I've started to develop a search for
my PHP site, and I'm using FULLTEXT index

After all, I created the indexs in the required search fields "title"
and "text":
ALTER TABLE table1 ADD FULLTEXT(title, text);

and with the following query:

returns me the results that I want, for the search in table1.

Until now, everything works fine.

I want to include on this search: table2 and table3, both tables have
different structure, but they have the some common fields, title and

Is there any way to put in the same query, the search for a string
in 3 differents tables?

Re: 2 or more tables with FULLTEXT index

Quoted text here. Click to load it

Please do NOT multi-post
Cross-post if you really think it necessary but DO NOT CROSS POST. It
wastes people's time.

Site Timeline