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