在不同的表中创建搜索引擎

Question

What would you suggest to me, to use for searching in different tables for search engine ?

Each table is different from the other, columns are different and the number of rows are different.

Answer 1

Create triggers on corresponding tables to fetch the content from different tables to a single table. Apply Full Text Search Indexing on that table.