SELECT * FROM pet WHERE name REGEXP 'w';

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

SELECT * FROM pet WHERE name REGEXP 'w';

posted on 2014-01-08 11:46  语辰  阅读(402)  评论(0编辑  收藏  举报