If I want to update an existing record in a table I use the UPDATE Command

The UPDATE Command is typically used in conjunction with the SET and WHERE Commands

The UPDATE Command Deletes the existing data in favor of the new data

It is time to promote some of our Star Fleet Personnel to Admiral

UPDATE sfmembers SET rankofrecord = 'Admiral' WHERE memberID IN (1,3,4,10,14);

Changing Information In A Current Record