SELECT * FROM users WHERE firstname LIKE '%o%'
In total, the number of retrieved records is 3.

Shoyo
Tobio
Ryunosuke