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 `client_into`;
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 `client_into`;