I have 2 tables which have full text index on each of their columns.
Table 1 - forums_topics field - topic
Table 2 - forums_messages field - message
Is it possible to search them both in one query and determine which table
the result is being returned from in the search results?
Thanks
Maybe something like this:
select ft.topic, fm.message from forums_topics ft, forums_messages fm
match (ft.topic, fm.message) against (...)
if topic is null then the hit is from fm and vice versa... haven't tried
it, so might not work :)
Steffan A. Cline wrote:
I have 2 tables which have