SQL – Update multiple records in one query

I have table – config.
Schema:
config_name | config_value

And I would like to update multiple records in one query. I try like that:

UPDATE config 
SET t1.config_value="value"
  , t2.config_value="value2" 
WHERE t1.config_name="name1" 
  AND t2.config_name="name2";

but that query is wrong 🙁

Can you help me?

1Best Answer
13