Update syntax introduction:
Update command alters the data contained in the table. It can change multiple columns at once and use multiple conditions.
update tablename set col1=2, col2='string' where col0=0
This will effectively update the two mentioned columns in the row that matches the condition after the where modifier.