title: how to use LIMIT in discontinuous data?
body: <p>I have a sql query like the following</p>
  
  <pre><code>    mysql_query("
  SELECT * 
  FROM students1
  WHERE
  (
      PartCode = '$s1' 
      AND (ElectiveSubject1='$s11' 
          OR ElectiveSubject2='$s11'
          OR ElectiveSubject3='$s11')
  )
  OR
  (
      PartCode = '$s2'
      AND (ElectiveSubject1='$s22'
          OR ElectiveSubject2='$s22'
          OR ElectiveSubject3='$s22')
  )
  ORDER BY AdmitCode, RollCode LIMIT 5, 8");
  </code></pre>
  
  <p>it returns first 8 rows starting from 6th. But I need the rows from 6 to 13 and from 65 to 69 as a single set, ie I have to combine <code>LIMIT 5,8</code> and <code>LIMIT 64, 5</code>. </p>
  
  <p>How to do this?</p>