海口手机版网站建设,广州网站建设推荐乐云seo,微信社区官网,备案网站iprow1#xff1a; abcsev.com.cn; 123seeco.com; efsevloal.com; dddseobal.com row2#xff1a; AAAAse23vloal.com; BBBBseo234bal.com 把同一個Column的字符串#xff0c;通過分隔符分割后逐行插入數據庫。
substring_index 定位是位置的左边#xff0c;或者右边。而不能… row1 abcsev.com.cn; 123seeco.com; efsevloal.com; dddseobal.com row2 AAAAse23vloal.com; BBBBseo234bal.com 把同一個Column的字符串通過分隔符分割后逐行插入數據庫。
substring_index 定位是位置的左边或者右边。而不能准确定位字符需要做判断来返回正确的结果。
SELECT * FROM temp_biz_email
WHERE email_toech.com.cnINSERT temp_biz_email2(cust_no,email,carbon)
SELECT cust_no,
SUBSTRING_INDEX(email_to,;,1)
AS to1,1 FROM temp_biz_emailINSERT temp_biz_email2(cust_no,email,carbon)
SELECT * from (
SELECT cust_no,
IF (SUBSTRING_INDEX(email_to,;,1) email_to,NULL,
SUBSTRING_INDEX(
SUBSTRING_INDEX(email_to,;,2),;,-1))
AS email_to,1
FROM temp_biz_email
) AS tab WHERE tab.email_to !
对于第一个匹配的位置可能会出现空的情况例如 去除null
INSERT temp_biz_email2(cust_no,email,carbon)
SELECT * from (
SELECT cust_no,SUBSTRING_INDEX(email_cc,;,1)
AS email_cc,1 FROM temp_biz_email
) AS tab WHERE tab.email_cc ! AND email_cc not LIKE %eaddeek.com%
