MYSQL - How to use UPDATE with IF-ELSE condition
Posted: Fri Oct 15, 2010 4:54 am
I have three columns - id, programname, status
I wanted to use UPDATE with IF condition something like this:
I am not sure if it'll be possible. Please suggest the best possible ways to do this.
Thank you
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