Mysql if example

Mysql if

SELECT user_display_image AS user_image,
       user_display_name AS user_name,
       invitee_phone,
       (CASE WHEN invitee_status = 1 THEN "attending"
             WHEN invitee_status = 2 THEN "unsure"
             WHEN invitee_status = 3 THEN "declined"
             WHEN invitee_status = 0 THEN "notreviwed"
       END) AS invitee_status
  FROM your_table

-1

Source: stackoverflow.com

Similar codes

0 vote368 views1 answer
Cahnge column name apex oracle
SQL
0 vote334 views2 answers
How to combine diff colmun value using group by postgres
SQL
1 vote316 views1 answer
Autocommit mysql
SQL
9 votes380 views3 answers
Import DB through mysql console
SQL
0 vote331 views1 answer
Soql last week
SQL
0 vote345 views1 answer
Can we rollback in sql
SQL
10 votes343 views4 answers
How to alter table name in mysql
SQL
0 vote336 views1 answer
Codigo crear tablas sql server
SQL
1 vote342 views1 answer
Drop function
SQL
3 votes393 views2 answers
See mysql users ubuntu
SQL