Request: Update a field depending on another field

Question

For some reason, the request does not want to work:

UPDATE table SET field1 = IF(field2 = 0, 1, field1) WHERE id = ' . $id;

Did I build it right? It is necessary, depending on the value of the field, to write another value in it or leave it as before.

Saidolim saidolim 7,898 3 nineteen 39 · Accepted Answer · 2015-10-02T11:41:22

Maybe so?

 UPDATE table SET field1 = CASE WHEN field2 = 0 THEN 1 ELSE field1 END

PashaPash ♦ 42.4k 9 60 130 · Answer 2 · 2015-10-02T11:42:33

 SELECT CASE <variable> WHEN <value> THEN <returnvalue> WHEN <othervalue> THEN <returnthis> ELSE <returndefaultcase> END FROM <table>

Adjust for yourself.

PashaPash ♦ 42.4k 9 60 130 · Answer 3 · 2015-10-02T13:20:57

It seems to me that the request simply lacks one little letter:

 UPDATE table SET field1 = IIF(field2 = 0, 1, field1) WHERE id = ' . $id;

3 answers 3