Need help with Conditional Update Statement

[JeffGSR]

I have the following statement:

UPDATE 
    tournaments
SET 
    tournament_player1 = IF (tournament_player1 = 5, 1, 0), 
 
    tournament_player2 = IF (tournament_player2 = 5, 1, 0),
 
    tournament_player3 = IF (tournament_player3 = 5, 1, 0),
 
    tournament_player4 = IF (tournament_player4 = 5, 1, 0)
 
WHERE
    tournament_time = 1 AND tournament_game = 1

This statement checks if each field is 5 then updates the field to 1, but if the field is not 5 then it updates the field to 0. I want to make it so the field is left alone if the field is not 5. How can this be done?

[JeffGSR]

I found the solution:

UPDATE 
    tournaments
SET 
    tournament_player1 = IF (tournament_player1 = 5, 1, tournament_player1), 
 
    tournament_player2 = IF (tournament_player2 = 5, 1, tournament_player2),
 
    tournament_player3 = IF (tournament_player3 = 5, 1, tournament_player3),
 
    tournament_player4 = IF (tournament_player4 = 5, 1, tournament_player4)
 
WHERE
    tournament_time = 1 AND tournament_game = 1

[longneck]

you might want to look at the CASE statement instead, which is standard SQL, while IF() is not.