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 vote117 views1 answer
Sql server express download
SQL
0 vote126 views2 answers
Laravel: customize or extend notifications - database model
SQL
1 vote123 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote109 views1 answer
Mysql default timestamp value to be current timestamp
SQL
7 votes120 views3 answers
Postgresql dump and restore db
SQL
0 vote112 views1 answer
Login failed for login due to trigger execution
SQL
0 vote111 views1 answer
Create table with primary key and foreign key in sql server
SQL
1 vote121 views1 answer
Postgres killing connections on db
SQL
0 vote127 views2 answers
What is the default password for sql server sa
SQL
1 vote152 views2 answers
Install sql server management studio ubuntu
SQL