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

61 votes1.2K views6 answers
Mysql add column
SQL
5 votes178 views4 answers
Describe table postgres
SQL
0 vote177 views1 answer
Cast for print sql
SQL
-2 votes192 views1 answer
Modify column name in tsql
SQL
7 votes183 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote201 views1 answer
How to to get time in sql
SQL
4 votes187 views1 answer
Restart for pg_hba.conf file
SQL
2 votes184 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes221 views1 answer
How to delete all duplicate items in mysql
SQL
3 votes315 views2 answers
Oracle sql first day of month
SQL