Posted by saavedrajj on 06/14/07 16:03

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:
SELECT * FROM table1 WHERE MATCH(title, text) AGAINST
('$search_string');

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
text.

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

• Next in forum: Re: How to Enumerate and Calculate Timezones?
• Prev in forum: Re: echo or ?><?php
• Thread view: 2 or more tables with FULLTEXT index

[Reply to this message]