SQL 笔记

更新指定字段属性

update user set sentsms='yes' where mobile='13488888338';

SELECT * FROM `user` WHERE sentsms = 'yes'; 
update `user` set `weixin`=replace(`weixin`,' ','');

mysql 根据长度常洵正则查询手机号

SELECT * FROM USER WHERE LENGTH(mobile) = 11

SELECT * FROM USER WHERE mobile REGEXP "^[1][356789][0-9]{9}$";

SQLSERVER 查询数据库中所有85年之后出生的 男性 手机号为11位的地址不含北京

SELECT [MobilePhone],[FirstName],[Birthday],[EMail],[CtfId],[Address] FROM [shifenzheng].[dbo].[cdsgus] where Birthday>'1985-01-01' and Gender='M' and len(MobilePhone)=11  and Address not LIKE '北京%'

SQLSERVER 查询数据库中所有85年之后出生的 男性 手机号为11位的

SELECT [MobilePhone],[FirstName],[Birthday],[EMail] FROM [shifenzheng].[dbo].[cdsgus] where Birthday>'1985-01-01' and Gender='M' and len(MobilePhone)=11