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 vote339 views1 answer
Openquery insert into linked server
SQL
6 votes316 views2 answers
Mysql set primary key
SQL
0 vote345 views2 answers
Start mysql server using docker
SQL
1 vote330 views1 answer
Postgres get month name from date
SQL
0 vote326 views1 answer
How to stop all connections to a psql 12 database?
SQL
1 vote352 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote340 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
1 vote361 views1 answer
Login to database mysql terminal
SQL
0 vote300 views1 answer
Declaring variables in pl sql
SQL
0 vote318 views1 answer
Test connection to sql server
SQL