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

0 vote215 views1 answer
Take sql dump in to file
SQL
0 vote234 views1 answer
Check database restore status sql script
SQL
0 vote179 views1 answer
Sql row number in result set
SQL
1 vote191 views1 answer
Oracle create program if no exists
SQL
1 vote247 views1 answer
Mysql show database size in mb
SQL
4 votes169 views3 answers
Order by value mysql
SQL
2 votes175 views1 answer
How to select first row of database sql
SQL
0 vote188 views1 answer
Unique index in mysql
SQL
0 vote169 views1 answer
Mysql select where text contains
SQL
0 vote204 views1 answer
Oracle execute package dblink
SQL