mySQL Update Column

You want to update a complete column in mySQL, e.g. you want to change the country code for Great Britain from ‘GB’ to ‘UK’

UPDATE dog SET landofbirth = 'UK' WHERE landofbirth = 'GB' 
UPDATE table SET column = 'new text' WHERE column = 'old text'