In an update statement, it is the WHERE clause that determines how many records which will be updated.
The WHERE clause:
WHERE Country='Mexico' will update all records which have the value "Mexico" in the field "Country".Example
UPDATE Customers
SET ContactName='Juan'
WHERE Country='Mexico';
EmoticonEmoticon