I wanted to use UPDATE with IF condition something like this:
Code: Select all
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
I am not sure if it'll be possible. Please suggest the best possible ways to do this.
Thank you