Sorting output by index in string?

Question

MySQL

Let's say I have a query like

SELECT command_name, command_class_name, command_args 
FROM commands 
WHERE 'тир {DIALOG} погода 1' LIKE CONCAT('%', command_name, '%');

And the result is like

{DIALOG} *** ***
погода *** ***
тир *** ***

It is clear that the database sorts them according to the principle "higher is the position of the result, the row of which is earlier in the table".
How to sort them according to the principle "higher is the position of the result that is earlier in the search string"?
LOCATE() / INSTR()
Is it worth it to do this using MySQL, or is it better to sort using the programming language?

Answer 1

How to sort them according to the principle "higher is the position of the result that is earlier in the search string"?
Use LOCATE() / INSTR()
Question updated.