SQLite Select from where column contains string?

What I currently have selects based on a column having the same value..

"SELECT * FROM users WHERE uuid = ?"

But what if I want to return a row based on one of the columns "containing" a string value? Some pseudo code would be:

SELECT * FROM users
WHERE column CONTAINS mystring

Any help is appreciated, I have been searching for other answers but to no avail.