MYSQL - How to use UPDATE with IF-ELSE condition

Junior WebHelper Joined: 04 Nov 2010 Posts: 2

I have three columns - id, programname, status

I wanted to use UPDATE with IF condition something like this:

Code:

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

Junior WebHelper Joined: 30 Nov 2010 Posts: 1

Try following.

Code:

UPDATE elec_products
SET STATUS = CASE
WHEN programname = 'Argos' THEN
1
WHEN programname = 'sify' THEN
2
ELSE
3
END
WHERE programname IS NOT NULL;