SQL IF ELSE

Else if sql

UPDATE table 
SET columnB = CASE fieldA 
        WHEN columnA=1 THEN 'x' 
        WHEN columnA=2 THEN 'y' 
        ELSE 'z' 
      END 
WHERE columnC = 1

Source: stackoverflow.com

Similar codes

2 votes187 views3 answers
Mysql cheat sheet
SQL
0 vote154 views1 answer
Create a plsql object
SQL
0 vote138 views1 answer
Postgres populate table from another table
SQL
2 votes131 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote173 views1 answer
Postgres row expiration
SQL
0 vote143 views1 answer
Postgres in operator with comma separated values
SQL
21 votes137 views1 answer
Cheatsheet for sql
SQL
0 vote139 views1 answer
Sqlite update only if greater
SQL
3 votes160 views1 answer
How to uninstall microsoft sql server
SQL
0 vote144 views7 answers
10 random questions use python and SQL
SQL