MySql 24 hours intervals select

MySql 24 hours intervals select References I need to group rows from a table by 24 hours intervals as below // SELECT count(user_id), DATE(created) as day FROM table GROUP BY day // SELECT * FROM table GROUP BY DATE(created) but i need the selection to be made by 24 hours intervals starting at 12:00:00 not 00:00:00 Thanks