For example, there is a mysql statement like this:

select * from city where city_name like '%hf%' order by created_at;

How to create an index for such a sql statement? If you want to create a composite index, use:

key(created_at,city_name)

Since created_at is in front, it degenerates into key(created_at) according to the leftmost matching principle of the index.

key(city_name,created_at)

Definitely not possible. The previous one was a fuzzy query, and this composite index degenerated into key (city). In this case, can only a single index column be created to solve the problem?
Please give me some advice.