SELECT * FROM users
WHERE name LIKE '%john%';