 Posted: Tue 4:41, 30 Nov 2010 Post subject: MYSQL - How to use UPDATE with IF-ELSE condition |
|
| 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 |
|
