MYSQL Is it possible to do a full text search on two columns in different tables?

Question

MySQL

Is it possible to do a full text search on two columns in different tables? If there is a table One with a one_one column, and a table Two with a two_two column, is it possible to do a FULLTEXT search on those two columns? Or is it better to transfer column two from table Two to table One (make the third column - three), and make an index on columns one and three (created)? If possible, can you give an example of how?

Answer 1

if monsieur is a pervert