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