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

1 vote116 views1 answer
Mysql column start with string
SQL
25 votes123 views5 answers
Uninstall mysql ubuntu
SQL
0 vote94 views1 answer
Call procedure in wordpress
SQL
0 vote102 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote106 views1 answer
Sql composite key
SQL
7 votes73 views1 answer
Alter table add key sql
SQL
0 vote101 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
11 votes106 views5 answers
How to install sqlite3 python
SQL
9 votes116 views5 answers
Laravel to sql
SQL
3 votes113 views2 answers
Sql random integer
SQL