update defense_appuser
set appstatus=case when action_time<'2014-01-01' then 0 else appstatus end
where open_id=你要更新的id
set appstatus=case when action_time<'2014-01-01' then 0 else appstatus end
where open_id=你要更新的id
set appstatus = 0
where open_id = xxx and action_time > '2014-01-01'