Mysql case when on date

SELECT
  id,
  CASE
    WHEN date_activated > '2011-11-23 18:30:00' THEN 'after'
    WHEN date_activated > '2010-01-20 00:00:00' THEN 'before'
    ELSE 'not yet'
  END AS date_note
FROM table1;

Source: stackoverflow.com

Similar codes

1 vote207 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
2 votes206 views2 answers
Mysql date range
SQL
0 vote159 views1 answer
Turn on foreign keys check mysql
SQL
1 vote158 views1 answer
Mysql count multiple columns in one query
SQL
0 vote104 views1 answer
Update row in sqlite python
SQL
0 vote161 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote163 views1 answer
Modifier une valeur sql
SQL
0 vote158 views1 answer
Mysql update privileges
SQL
5 votes113 views1 answer
Postgres upsert
SQL
1 vote189 views1 answer
Wordpress change url phpmyadmin
SQL