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.

Hits: 732