Евгений

mysql> CALL SNIPPETS('hello this is my document text world ', 'indxproduct', 'hello world', 5 AS around, 200 AS limit);
+-------------------------------------------------------------------------------+
| snippet |
+--------------------------------------------------------------------------------+
| hello this is my document text world |
+--------------------------------------------------------------------------------+

Или напишите UDF свою пользовательскую ф-цию сортировки

ORDER BY FIND_IN_SET(folders, '123,5456,789')