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

bough

Not quite sure what you mean in your question, do you want to know if you can search across several tables in one query?

Roger_Ramjet

Not possible to create an FTS index across 2 tables. You can however query multiple tables in 1 query if each has it's own FTS index. If the tables are related then you use a join, if not then a UNION query with selects that match against each table in turn would be most efficient.