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

8 votes185 views1 answer
Today minus 15 days postgresql
SQL
1 vote172 views1 answer
User privileges postgresql information_schema
SQL
3 votes187 views1 answer
Oracle transaction commit rollback example
SQL
1 vote199 views1 answer
Mysql datetime with timezone offset
SQL
0 vote192 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote175 views1 answer
Mod in sql
SQL
0 vote181 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
0 vote165 views1 answer
Order by with where clause in mysql
SQL
1 vote245 views2 answers
Begin transaction sql
SQL
1 vote238 views4 answers
How to check table in postgresql from terminal
SQL