SELECT username,DATE_FORMAT(coldate,'%Y-%m-%d') dd,MIN(coldate),MAX(coldate) FROM TABLE GROUP BY username,dd