门店会员姓名手机号未填写处理

wbv123

–查询电话为空
select handset,* from u_memcard_reg_note where ISNULL(handset,”)=”
–更新
update u_memcard_reg_note set handset=’123456′ where ISNULL(handset,”)=”

–查询持卡人为空
select cardholder,* from u_memcard_reg_note where ISNULL(cardholder,”)=”

–更新
update u_memcard_reg_note set handset=’未填写’ where ISNULL(cardholder,”)=”