Is there any query in sqlite to choose a substring?

Lets say I have a table Y with column X.

There is one row of "X" with the string "abcdefg", and another row with "qwerty".

Can I make a SELECT query in sqlite to choose the row wh开发者_开发问答ich contains the substring "abcd" ?

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