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 vote222 views2 answers
Nodejs mysql convert to plain object
SQL
1 vote207 views1 answer
Mysql get character set
SQL
0 vote217 views1 answer
Sql ignore
SQL
0 vote200 views1 answer
Convert sql server guid to varbinary
SQL
5 votes213 views3 answers
Day of week postgresql
SQL
0 vote202 views1 answer
Changer un mot de passe mysql
SQL
0 vote186 views1 answer
Get number of table colums in sql query
SQL
5 votes199 views2 answers
Mysql where in array
SQL
3 votes211 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote212 views1 answer
Mysql date minus 1 day
SQL