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

Question

如何在 table_a table_b table_c 中搜索具有随机列数的字符串？

我知道这不是正确的 sql，但它会是这样的:

SELECT * FROM users, accounts, something_else WHERE ->ANY COLUMN CONTAINS 'this_string'<-

提前为 SO 社区打个招呼

Answer 1

添加fulltext indexes到所有这些表中的所有字符串列，然后合并结果

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