'Update value from table column based on the value from another column

I have the table: countries and columns Country and Status I wish to update only the values from the Status column based on a value from the Country column. SMTH like this

update ban_country_ip set
checkbox = 0
where country_name = United States

This syntax doesn't work.

mysql


Solution 1:[1]

update countries
set `status`= 0
where country_name = 'United States'

Solution 2:[2]

update countries set
Status = 0
where Country = 'United States'

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 juergen d
Solution 2 sunysen

Related Questions