I have something like:
INSERT INTO tbl (count,otherID) VALUES (2,'a') ON DUPLICATE KEY UPDATE count = 2
I would like to update count only if the new value is greater than the current value. So let's say there is already a record with count: 4 and otherID: 'a' that ON DUPLICATE KEY UPDATE count = 3
should not be triggered
How can i achive this?
can i use if? ... UPDATE count = IF (NEWVALUE > count) NEWVALUE else count