Q:

MySQL's IF leave second value blank

In MySql's IF single line version, how can I specify do nothing for the second value? Eg:
Update table set col = IF(score < 10,1, #Do nothing if it's > 10) where userId = 5

So, if the score were < 10, then do the update or else do nothing. Is this possible, or is there another way to do it perhaps? Seems like I need to supply a value there compulsarily

A:

Do this:
Update table set col = IF(score < 10,1, col) where userId = 5

