I wanted to use UPDATE with IF condition something like this:
UPDATE elec_products
IF(programname ='Argos')
(
SET status = 1
)
ELSEIF(programname ='sify')
(
SET status = 2
)
ELSE
(
SET status = 3
)
ENDIF
WHERE programname IS NOT NULL
Code (markup):
I am not sure if it'll be possible. Please suggest the best possible ways to do this.
Thank you
from MySQL https://ift.tt/3aw3TFW
via IFTTT
0 Comments