MySQL：如何在多个表中搜索任何列中存在的字符串

MySQL：如何在多个表中搜索任何列中存在的字符串

将全文索引添加到所有这些表中的所有字符串列，然后合并结果

select * from table1 where match(col1, col2, col3) against ('some string')union allselect * from table2 where match(col1, col2) against ('some string')union allselect * from table3 where match(col1, col2, col3, col4) against ('some string')...