The WHERE clause performs two functions:
If no WHERE clause is specified all rows in the table are updated.
This UPDATE statement implements a name change for one of the shippers:
UPDATE Northwind.dbo.Shippers
SET CompanyName = 'United Shippers'
WHERE CompanyName = 'United Packages'