MYSQL - How to use UPDATE with IF-ELSE condition

[rahulephp]

I have three columns -  id, programname, status

 

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

 

 

I am not sure if it'll be possible. Please suggest the best possible ways to do this.

Thank you

[awjudd]

Try using a CASE statement instead.

 

UPDATE elec_products SET stats = CASE programmename WHEN 'Argos' THEN 1 WHEN 'stify' THEN 2 ELSE 3 END CASE WHERE programmename IS NOT NULL

 

~judda

[rahulephp]

Thats great.

Thanks a lot.