Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select count(*) from subscribers where status = 'new' and activated_at <= '2009-11-16';
- +----------+
- | count(*) |
- +----------+
- | 43669 |
- +----------+
- 1 row in set (0.88 sec)
- mysql> select count(*) from subscribers where status = 'new' and activated_at = '2009-11-16';
- +----------+
- | count(*) |
- +----------+
- | 8 |
- +----------+
- 1 row in set (0.87 sec)
Add Comment
Please, Sign In to add comment