开头是"淘"
SELECT * FROM `website` WHERE `name` REGEXP '^淘';
结尾是"宝"
SELECT * FROM `website` WHERE `name` REGEXP '宝$';
包含"宝"
SELECT * FROM `website` WHERE `name` REGEXP '[宝]';
SELECT * FROM `website` WHERE `name` REGEXP '宝';
不包含"淘宝"
SELECT * FROM `website` WHERE `name` REGEXP '[^淘宝]';
包含"菜鸟"或者"微博"
SELECT * FROM `website` WHERE `name` REGEXP '菜鸟|微博';
包含"www"和"oo"
SELECT * FROM `website` WHERE `web_url` REGEXP '.*www.*oo.*';
有0个或多个"w"
SELECT * FROM `website` WHERE `web_url` REGEXP 'w*';
有1个或多个"t"
SELECT * FROM `website` WHERE `web_url` REGEXP 'ht+ps://taobao.com';
有2个"o"
SELECT * FROM `website` WHERE `web_url` REGEXP 'o{2}';
有2-3个"o"
SELECT * FROM `website` WHERE `web_url` REGEXP 'o{2,3}';
以https开头并以cn结尾
SELECT * FROM `website` WHERE `web_url` REGEXP '^https' AND `web_url` REGEXP 'cn$';
SELECT * FROM `website` WHERE `web_url` REGEXP '^https.*cn$';
网友评论