SELECT * FROM pet WHERE name REGEXP 'w'; To find names containing a “w”, use this query: SELECT * FROM pet WHERE name REGEXP 'w';