数据库 | MySQL | 7. 正则表达式

开头是"淘"

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$';