随笔分类 -  mysql

mysql 语句整理
摘要：sql正则 SELECT emall,case when emall REGEXP '^[a-zA-Z0-9]+[.+-]+[a-zA-Z0-9]+@[a-zA-Z0-9.-]+\.[a-zA-Z0-9.-]+$' then '符合' else '不符合' end as result FROM `c 阅读全文
posted @ 2023-05-04 16:21 KTalk 阅读(12) 评论(0) 推荐(0) 编辑