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 vote405 views1 answer
Mysql backup query
SQL
0 vote440 views1 answer
Stop and start mysql
SQL
1 vote348 views1 answer
Get parameter value in mysql trigger
SQL
14 votes365 views1 answer
Oracle new column
SQL
6 votes373 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote363 views1 answer
Renombrar tabla mysql
SQL
5 votes339 views3 answers
Mysql extract month from date
SQL
0 vote348 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
2 votes339 views2 answers
Mysql date range
SQL
2 votes372 views1 answer
Merge firstname and lastname in sql oracle
SQL