Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- 2 or more tables with FULLTEXT index
June 14, 2007, 4:03 pm
rate this thread
my PHP site, and I'm using FULLTEXT index
After all, I created the indexs in the required search fields "title"
ALTER TABLE table1 ADD FULLTEXT(title, text);
and with the following query:
SELECT * FROM table1 WHERE MATCH(title, text) AGAINST
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?
- » ssh on command line: force using a group size (prime size) of 1024 (and no...
- — The site's Newest Thread. Posted in » Secure Shell Forum