Code:
UPDATE tablename set columnname=newdata where primarykeytable=X
Example: UPDATE inventory set Color='Red' where Flowers='1';

Can be entered with or without the ' (tick) marks.