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_strin g');
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?
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_strin g');
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?
Comment