Recent Posts

Caution: Greetings to all visitors. The site is working in short. Links Please skip the link to view any topic and thank you for visiting
header ads

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
Code (markup):

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

from MySQL https://ift.tt/3aw3TFW
via IFTTT

Post a Comment

0 Comments