更新指定字段属性 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 m