SQLize Online / PHPize Online  /  SQLtest Online

create table t1 (id int, type int, data int, date datetime); insert into t1 values (1, 5555, 44, "2017-5-4-15.25.45"), (2, 5555, 22, "2017-5-4-15.25.50"), (3, 5555, 11, "2017-5-4-15.25.55"), (4, 4444, 44, "2017-5-4-15.26.00"), (5, 4444, 22, "2017-5-4-15.26.05"), (6, 4444, 11, "2017-5-4-15.26.10"), (1, 5555, 44, "2017-5-4-15.26.15"), (2, 5555, 22, "2017-5-4-15.26.20"), (3, 5555, 11, "2017-5-4-15.26.25"), (4, 4444, 44, "2017-5-4-15.26.30"), (5, 4444, 22, "2017-5-4-15.26.35"), (6, 4444, 11, "2017-5-4-15.26.40"), (1, 5555, 44, "2017-5-4-15.26.45"), (2, 5555, 22, "2017-5-4-15.26.50"), (3, 5555, 11, "2017-5-4-15.26.55"); select * from t1 where type = 4444 and date between '2017-5-4-12.00.00' and '2017-5-4-17.59.59';