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 vote132 views1 answer
Oracle change password expiration policy
SQL
0 vote127 views1 answer
Mysql url data type
SQL
2 votes127 views2 answers
Mysql limit
SQL
1 vote113 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote118 views1 answer
Jdbc sql connection string
SQL
1 vote118 views1 answer
Sql first
SQL
27 votes134 views3 answers
Mysql show tables in database
SQL
-1 vote116 views1 answer
How to open blade file from blade in laravel
SQL
0 vote119 views1 answer
Sql pad left 0
SQL
1 vote115 views2 answers
Mysql spring boot application.properties
SQL