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

0 vote135 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote119 views1 answer
Show specific events on mysql
SQL
0 vote130 views1 answer
How to check xampp mysql password
SQL
0 vote127 views1 answer
Pl/sql loop example
SQL
3 votes125 views4 answers
Ubuntu stop mysql
SQL
13 votes200 views4 answers
Mysql remove foreign key constraint
SQL
4 votes185 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
2 votes128 views2 answers
Sql first character
SQL
0 vote141 views1 answer
Alter fedora mysql 8.0 user
SQL
18 votes133 views4 answers
Uninstall mysql on ubuntu
SQL