Sort by earlier occurrence of a string in a query?

Question

PostgreSQL

There is such a request. By the string transmitted by the user, we are looking for something in the database

SELECT email FROM users WHERE email ILIKE :query ORDER BY email

We get such a list for the request "test"

SELECT email FROM users WHERE email ILIKE "%test%" ORDER BY email

[email protected]
[email protected]
[email protected]
[email protected]
[email protected]

_
_
_
_ oiu
[email protected]
[email protected]

Is it possible to do this at the sql query level?

Answer 1

It is necessary to sort by the Levenshtein distance from the "test" expression to the email field.

Answer 2

Postgres has ORDER BY POSITION()
ORDER BY POSITION('test' in email)