LIKE operator

SQL allows you to write Wildcards using % and LIKE which will match a specific pattern in a column

SELECT username from User WHERE name LIKE "%oskar%"