Re: MATCH AGAINST on two tables

[Rick James]

Eh? You want substrings? Or was that a poor example of what you are after?

To get all the rows you specify:

SELECT a.aname,
       b.bname
   FROM a, b;

You might be able to add to that
MATCH(aname) AGAINST ('...') +
MATCH(bname) AGAINST ('...') +
but I don't know what strings you are looking for.