Update using case in mysql

UPDATE `table` SET `uid` = CASE
    WHEN id = 1 THEN 2952
    WHEN id = 2 THEN 4925
    WHEN id = 3 THEN 1592
    ELSE `uid`
    END
WHERE id  in (1,2,3)

Source: stackoverflow.com

Similar codes

0 vote146 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote145 views1 answer
Plsql check for string in numeric
SQL
0 vote159 views1 answer
This week mysql
SQL
0 vote273 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote131 views1 answer
Best sql course
SQL
4 votes225 views1 answer
What are the data types
SQL
0 vote139 views1 answer
How to install mysql without admin rights
SQL
13 votes130 views6 answers
Restart postgresql
SQL
1 vote93 views1 answer
Mysql collation
SQL
1 vote139 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL