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

1 vote324 views1 answer
How to see logical reads in sql server
SQL
0 vote278 views1 answer
Sql grant select only
SQL
0 vote297 views1 answer
Database xml sql
SQL
1 vote285 views1 answer
Sql in array query
SQL
0 vote280 views1 answer
Sql server convert date to weekday
SQL
0 vote290 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote272 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote276 views1 answer
Sql combine results from two tables
SQL
0 vote288 views1 answer
Fast sql column count
SQL
0 vote284 views1 answer
How to create a table in sql stack overflow
SQL