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'

Leave a Reply

Your email address will not be published. Required fields are marked *