mysql> SELECT * FROM options;
+----+------+---------+
| id | name | value |
+----+------+---------+
| 1 | aa | a value |
| 2 | bb | b value |
| 3 | cc | c value |
| 4 | dd | d value |
| 5 | ee | e value |
+----+------+---------+
I have a options table.
I want to Update multi row in same query (with where case name).
suppose i update options.name aa and bb at one time. It's update like
+----+------+---------+
| id | name | value |
+----+------+---------+
| 1 | aa |aa value |
| 2 | bb |bb value |
+----+------+---------+
I try to solve this problem by googling but i can't.
Please Help me and little bit explain for the query.