setting multiple column using one update
How to set multiple columns of a table using update query in mysql?
Just add parameters, split by comma:
UPDATE tablename SET column1 = "value1", column2 = "value2" ....
See also: mySQL manual on UPDATE
UPDATE some_table
SET this_column=x, that_column=y
WHERE something LIKE 'them'