Help for this page

Select Code to Download


  1. or download this
    CREATE TABLE genome (
      id int AUTO_INCREMENT PRIMARY KEY,
    ...
      INDEX end
      ...  -- index other fields that are often useful in queries
    )
    
  2. or download this
    -- assume your current input data record has a "position" value of 876
    +5:
    
    select * from genome where start <= 8765 and end >= 8765