那这样
UPDATE player_techs SET progress=(SELECT research_Cost)-1000 WHERE player_id=1 AND state=0
UPDATE player_techs SET progress=(SELECT research_Cost)-1000 WHERE player_id=1 AND state=1
UPDATE player_techs SET progress=(SELECT research_Cost)-1000 WHERE player_id=1 AND state=7
各执行一遍