I've joined several columns from several tables, and I would like to
perform a relevance match against these multiple columns.
It looks something like this:
SELECT * FROM table1 LEFT JOIN table2 ON table1.column1 = table2.column1
WHERE
MATCH
(
table1.column4, table2.column2)
AGAINST ('%test%')...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.