如何更新多个字段

Question

I have a table called users .

Users {name, team_id, overall_user_score}

I want to select all from a team (eg all from team 2) and add 1 to each users overall score taking into account the current score of each user.

I have the first part of the MySQL done, But I cant figure out how to actually update the score.

SELECT * from users WHERE team_id = $team UPDATE overall_user_score

Answer 1

Here is the correct SQL Query for updating.

UPDATE `users` SET `overall_user_score`=`overall_user_score`+1 WHERE team_id= "'.$team.'"