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

用逗号连接所有ID

SELECT GROUP_CONCAT(id SEPARATOR ',') AS ids FROM table