ERROR: Error 1064: You have an error in your SQL syntax; code example

Example: mysql #1064 error

UPDATE test
SET  field  = IF(something == 1{CONDITION}, 1 {NEW VALUE}, field)
WHERE `id` = 5