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 votes328 views3 answers
Mysql cheat sheet
SQL
0 vote390 views1 answer
Sqlite get date only
SQL
2 votes381 views1 answer
Orcale index size
SQL
0 vote343 views1 answer
Mysqlimport
SQL
0 vote343 views1 answer
Mysql date only no time
SQL
0 vote366 views1 answer
Str_to_date sql server
SQL
0 vote379 views1 answer
Nvl2 syntax
SQL
0 vote349 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
41 votes459 views6 answers
Alter table add column in SQL Server
SQL
2 votes362 views1 answer
Change primary key sql
SQL