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

4 votes333 views1 answer
Group by mysql and concatenate string
SQL
0 vote306 views1 answer
MySQL error code 2068
SQL
0 vote338 views1 answer
Query by column for substring sql
SQL
-1 vote355 views3 answers
PS5
SQL
0 vote331 views1 answer
Mysql min value row
SQL
0 vote405 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote313 views1 answer
Mysql procedure between two tables
SQL
0 vote340 views1 answer
Tsql table column constraint must be uppercase
SQL
1 vote333 views1 answer
Oracle select first result
SQL
0 vote343 views1 answer
Postgres regex word boundary
SQL