Calculate MATCH() AGAINST() scores from UNIFIED QUERY not FOR EACH TABLE
I want to have a
FULLTEXT INDEX on
data name in the base SELECT that selects data from another SELECT which unions several tables.
SELECT `data` FROM SELECT ( SELECT `name` as `data` FROM `names` UNION SELECT `title` as `data` FROM `titles` ) as `search`
data to have a FULLTEXT INDEX