How to get data which is added between hours in MySQL?

SELECT * FROM TABLE WHERE HOUR(time) BETWEEN 1 AND 2;

This query brings all records between 1 and 2 o’clock according to time field of you table. (time = The DB field which you save the time)