Can't find FULLTEXT index matching the column list in Union

50 Views Asked by At

I keep getting this error:

Can't find FULLTEXT index matching the column list

I already added ADD FULLTEXT function.

this is my code:

SELECT *, MATCH(text1, content) AGAINST('$name') AS score FROM subcont WHERE MATCH(text1, content) AGAINST('$name') ORDER BY score DESC LIMIT 4
0

There are 0 best solutions below