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

3 votes296 views2 answers
See mysql users ubuntu
SQL
13 votes261 views4 answers
Mysql get last row
SQL
0 vote291 views1 answer
Hour differeence in mysql
SQL
0 vote346 views1 answer
Sp help text in postgresql
SQL
1 vote270 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote299 views1 answer
Space not removing from column in sql
SQL
16 votes294 views2 answers
Mysql date between two dates
SQL
0 vote288 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote261 views2 answers
How to see table associated with a schema in sql
SQL
25 votes342 views5 answers
Mysql replace text
SQL