MySQL FULLTEXT搜索超过> 1表

SELECT * FROM table1 WHERE MATCH(column1, column2) AGAINST('search_term')
UNION
SELECT * FROM table2 WHERE MATCH(column1, column2) AGAINST('search_term')

CREATE TABLE federated_table (
  id INT(11) NOT NULL AUTO_INCREMENT,
  column1 VARCHAR(255),
  column2 VARCHAR(255),
  PRIMARY KEY (id)
) ENGINE=FEDERATED
DEFAULT CHARSET=utf8
CONNECTION='mysql://username:password@server_ip:port/database_name/table_name';

SELECT * FROM federated_table WHERE MATCH(column1, column2) AGAINST('search_term');