gmybft
Joined: 30 Nov 2010
Posts: 1
Read: 0 topics
Warns: 0/5
|
|
 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
The post has been approved 0 times
|
|
Profile
Log in to check your private messages
Log in
Register
