SELECT * FROM pet WHERE name REGEXP 'w';

To find names containing a “w”, use this query:

SELECT * FROM pet WHERE name REGEXP 'w';