Posted by Captain Paralytic on 06/14/07 16:10

On 14 Jun, 17:03, saavedrajj <saavedr...@gmail.com> wrote:
> 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?

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

[Back to original message]