Question

How to update MySQL table using SQL

Answer 1

UPDATE table_name 
SET 
    column_name = 0
WHERE
    column_name = 1;

 

70+ SQL courses for beginners and professionals

Answer 2

UPDATE table_name 
SET 
    column_name_1 = 0
WHERE
    column_name_2 LIKE "%abc%";

 

70+ SQL courses for beginners and professionals