MySql - How to toggle any value

Posted by Blake on 8/13/2013

This trick will work for both strings and numeric values. Basically with an update statement all you need to do is use an IF in the set portion of your query. In the below example I will toggle a string value of ‘true’ to ‘false’ and ‘false’ to ‘true’.


    update user_t
    set enable_user = IF(enable_user='true', 'false', 'true')
    where username='testuser';