CREATE TABLE events name VARCHAR(30), start INT(11) UNSIGNED, end INT(11) UNSIGNED; SELECT * FROM events WHERE start > @queryend AND end < @querystart