思路:
1.email是qq邮箱
2.qq邮箱也可以自己注册的,'@'前面有可能是随意填写的字符串,过滤'@'前面不是数字的
3.截取符合邮箱'@'前面部分即为qq号
select SUBSTRING(po.contact_email,0,CHARINDEX('@',po.contact_email)) from PASS_ORGANIZATION po
where CHARINDEX('@qq.com',po.contact_email) > 0
and ISNUMERIC(SUBSTRING(po.contact_email,0,CHARINDEX('@',po.contact_email))) > 0
select SUBSTRING(po.contact_email,0,CHARINDEX('@',po.contact_email)) from PASS_ORGANIZATION po
where CHARINDEX('@qq.com',po.contact_email) > 0
and ISNUMERIC(SUBSTRING(po.contact_email,0,CHARINDEX('@',po.contact_email))) > 0
sql语句用到了sql常用的3个函数,SUBSTRING CHARINDEX ISNUMERIC。分别说明如下:
</