SEO

#1 (**permalink**) 02-28-2008, 10:02 AM

Hi everybody, I need some help. I've started to develop a search for
my 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 ('SeachString');

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?

#2 (**permalink**) 02-28-2008, 10:02 AM

== Quote from saavedrajj (saavedrajj@gmail.com)'s article
> Hi everybody, I need some help. I've started to develop a search for
> my 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 ('SeachString');
> 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?

as long as you're retrieving the same fields (data type and field name), i believe
you can add a union and retrieve the combined results.
--
POST BY: lark with PHP News Reader

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

2 or more tables with FULLTEXT index