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 vote172 views1 answer
Best sql collation
SQL
0 vote189 views2 answers
Homebrew nysql launch
SQL
0 vote163 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
58 votes313 views6 answers
Create new user in postgres
SQL
1 vote175 views1 answer
Timestamp in sqlite
SQL
0 vote131 views2 answers
How to combine two sql queries in one result
SQL
7 votes173 views3 answers
Convert ansi sql
SQL
0 vote176 views1 answer
Postgres statistics
SQL
0 vote171 views1 answer
Mysql count unique in group statement
SQL
1 vote168 views1 answer
Mysql monthname
SQL