Is it possible to check the occurrence of a field value in a longer string with a sql query?

Question

MySQL

How would LIKE vice versa. Not the shorter one is contained in the field value, but the field value in the longer string.

Answer 1

Like this. If you need what you write in the comments. If that makes sense, I don't know.

SELECT *
FROM `users`
WHERE "Василий Пупкин" LIKE CONCAT( "%", name, "%" )

Answer 2

read will help