MYSQL question

running a search on multiple tables

[willis1480]

I am running a search on multiple pages for a match using:

...WHERE MATCH(table1.full_text_index) AGAINST ('string') OR MATCH (table2.full_text_index) AGAINST ('string') OR....

I want to be able to tell which table finds a match. And if there are multiple tables that find a match to able to identify that as well.

Does anyone know a better forum for MYSQL as well. I keep getting more into mysql and could use a more dedicated forum.

Thanks

[coopster]

Good question. I've never tried this, but how about qualifying the columns in the select list with the table name and giving them an alias?

Also, how about [forums.mysql.com...] ;)