How to display entries by day with matching values?

Question

MySQL

Hello. I have a table {id, idUsr, name, time}. Users appear every day. I need to find records that are duplicated, that is, when two records of the same user are in one day ( by idUsr ). I sent a request like this, but it will display only for the current day, but how can I do it for a month?

SELECT id, idUsr, name, time FROM users WHERE DATE(time) = '2016-08-01' GROUP BY idUsr HAVING COUNT(*) > 1;

Answer 1

SELECT id, idUsr, name, time FROM users WHERE DATE(time) BETWEEN '2016-08-01' AND '2016-08-31' GROUP BY idUsr HAVING COUNT(*) > 1

Answer 2

The usual solution is to JOIN the table with itself ON idUsr and date(time) are equal, but the id's are different.