title: Select * from tbl where id>=5 /* then add the result from id<5 to query */
body: <p>I have a table with 9 rows. </p>
  
  <p>$id=5<br>
  If i use <code>SELECT * FROM tbl WHERE id&gt;=$id</code> i get the 5,6,7,8,9 rows. To this query I want to add the result of <code>SELECT * FROM tbl WHERE id&lt;$id</code> so I will get the final 5,6,7,8,9,1,2,3,4 rows.</p>
  
  <p>This is to avoid going two times in database then add the result set in php.</p>
  
  <p>EDIT: Yes order is important. Thank you guys for the fast response. Thank you @knittl(Accepted answer) and @Swanand for the best answers.</p>