Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- itemID (BIGINT)
- userID (BIGINT)
- wasAdded (DATETIME)
- SELECT COUNT(*) FROM my_table WHERE userID = 'X' AND wasAdded BETWEEN '2008-01-01 00:00:00' AND '2008-01-01 23:59:59';
- SELECT COUNT(itemID) FROM 'tableName' WHERE TO_DAYS(wasAdded) = TO_DAYS(NOW()) AND userID = X
- SELECT userId, COUNT(*)
- FROM my_table
- WHERE '2008-01-01' <= wasAdded AND wasAdded < '2008-01-01' + 1
- GROUP BY userId
Add Comment
Please, Sign In to add comment