mysql if没用,在mysql中使用IF更新数据，如果为false，则定义“不做任何事情”

Im trying to use IF query in update some entire row in my mysql table. As known IF query have 3 parameters. Part 1 of what you looking for, part 2 if its found / true and part 3 if its not found / false.

I just want it to be update when its true and doing nothing if false. How to define 'dont do anything' so the false part wont be update into anything else? Sorry for my bad english. And thanks for your help.

解决方案

You can reassign the same value of column in FALSE part to do nothing.

Try this:

UPDATE tableA SET COL1 = IF(a=b, c, COL1)