setting multiple column using one update.

Question

How to set multiple columns of a table using update query in mysql?

Answer 1

Update some_table set this_column=x, that_column=y where something like 'them'

Answer 2

Just add parameters, split by comma:

UPDATE tablename SET column1 = "value1", column2 = "value2" ....

See also: mySQL manual on UPDATE