MySQL CHANGE value based on CONDITION

MYSQL CHEAT-SHEET

To  change a value based on a condition we can use the format as below;

UPDATE `tableName`

SET

    `col_name_one` = 'new_value',

    `col_name_two` = 8   

WHERE `col_name_three` = 2020110501;