Match Against

[jamal_dakak]

Hi,

Can someone help me with this. I want use a match against in search engine on multiple tables. In other term I want to create an index and fulltext across 2 tables.
Is this possible?

Thanks

[gardnc]

Not sure exactly what you need. Can you provide a simple example?

[Houdini]

You would probably have to make 2 queries one for each table with the fulltext index, but you could try doing it anyway and if you get an error then you would know for sure. I guess it would look like

SELECT * FROM tbl1, tbl2 WHERE MATCH(something) AGAINST ('someterm(s)');