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 vote267 views1 answer
Regex any word except sql
SQL
0 vote279 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
2 votes256 views1 answer
Mysql cannot delete or update a parent row
SQL
-1 vote272 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote265 views1 answer
Leftjoin in sql
SQL
10 votes243 views2 answers
Mysql select timestamp group by day
SQL
0 vote277 views1 answer
Search mysql database for column
SQL
0 vote271 views1 answer
Install squirrel sql ubuntu
SQL
4 votes297 views1 answer
Sql select limit range
SQL
1 vote261 views1 answer
Set all the vluses in calumn in sql to false
SQL