UPDATEing records in your database

UPDATE
UPDATE sometable SET somecol = 'someval'; #force ALL records to have a given value
UPDATE car SET color = 'cherry red' WHERE color = 'red'; #repainted all the red cars
UPDATE student SET nickname = 'chuck' WHERE id = 7;
UPDATE syntax reference