Is there any query in sqlite for selecting a substring?

Question

Suppose I have a table Y with column X.

There is one line "X" with the line "abcdefg" and another line with "qwerty".

Is it possible to make a SELECT query in sqlite to select a string containing the substring "abcd"?

Answer 1

SELECT * FROM Y WHERE X LIKE "%abcd%"