Searching for records of first names that have an 'o' in them:
SELECT firstName FROM assignment7 WHERE firstName LIKE '%o%'
In total 5 rows retrieved

Carlo
Isobella
Eloise
Bob
Koncha

Search done!