How to update all values in a column with a single Update query?

Question

I have a database table where I want to update all values in a column with a single update command. suppose I have a table TEST with having a column CITY,I want to update all values in City column with one value. What is the Query? if city has values like: sydney, brooklyn, manhatton then update command replace all these values with manhatton.

Answer 1

You can do a blanket UPDATE, specifying no restrictions on which records to update:

UPDATE TEST
SET CITY = 'New Value'