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

9 votes133 views4 answers
How to alter table column name in mysql
SQL
0 vote139 views1 answer
Into operator in sql
SQL
0 vote128 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote135 views1 answer
How to login to mysql in homestead
SQL
0 vote137 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote94 views1 answer
Mysql timeout 30 seconds
SQL
0 vote100 views1 answer
Copy data from cell to cell mysql
SQL
0 vote128 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote101 views2 answers
Avg() sql
SQL
2 votes133 views2 answers
Mysql count rows returned
SQL