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

2 votes256 views1 answer
Get first 2 letter in sql
SQL
2 votes270 views2 answers
Mysql on duplicate key update get value from values
SQL
4 votes290 views3 answers
Sql find second highest salary employee
SQL
4 votes255 views1 answer
Oracle select first 10 rows
SQL
0 vote256 views2 answers
Postgres another version
SQL
0 vote261 views1 answer
Java check if something is in mysql table
SQL
0 vote243 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote274 views1 answer
Show mysql account privilleges
SQL
0 vote264 views1 answer
Delete a record from a table sqlite3
SQL
0 vote315 views1 answer
Postgres extract number from string
SQL