SUBSTRING_INDEX(email ,'@',1) 查询@字符之前的符号
SUBSTRING_INDEX(email ,'@',-1) 查询@字符之后的符号
select user_id, user_name_en, CONCAT(SUBSTRING_INDEX(email ,'@',1),'20230410@',SUBSTRING_INDEX(email ,'@',-1)) from sys_user where deleted = 1 and email like '%@%';
SUBSTRING_INDEX(email ,'@',1) 查询@字符之前的符号
SUBSTRING_INDEX(email ,'@',-1) 查询@字符之后的符号
select user_id, user_name_en, CONCAT(SUBSTRING_INDEX(email ,'@',1),'20230410@',SUBSTRING_INDEX(email ,'@',-1)) from sys_user where deleted = 1 and email like '%@%';