CREATE TABLE genome ( id int AUTO_INCREMENT PRIMARY KEY, start int, end int, strand varchar(6), ... -- include other fields as needed INDEX start, INDEX end ... -- index other fields that are often useful in queries ) #### -- assume your current input data record has a "position" value of 8765: select * from genome where start <= 8765 and end >= 8765