Equivalent of SQL Server's CONTAINSTABLE in MySQL

Question

I am converting a Query from SQL Server to MySQL but I have a problem converting the sentence contains table , because it uses rank .

I′ve looked for a similar property but I didn′t find anything , here is my Query at SqlServer

SELECT KEY_TBL.RANK  
FROM CATS  
INNER JOIN  containsTABLE (CATS,(COLOR,CITY),'ORANGE',1000) AS KEY_TBL ON RUP.ID = KEY_TBL.[KEY]
ORDER BY RANK

question from:https://stackoverflow.com/questions/65946790/equivalent-of-sql-servers-containstable-in-mysql

Answer 1

Waitting for answers