Select * from tbl where id>=5 /* then add the result from id<5 to query */

Question

I have a table with 9 rows.

$id=5
If i use SELECT * FROM tbl WHERE id>=$id i get the 5,6,7,8,9 rows. To this query I want to add the result of SELECT * FROM tbl WHERE id<$id so I will get the final 5,6,7,8,9,1,2,3,4 rows.

This is to avoid going two times in database then add the result set in php.

EDIT: Yes order is important. Thank you guys for the fast response. Thank you @knittl(Accepted answer) and @Swanand for the best answers.

Answer 1

UNION is your friend!

(SELECT *,1 as q FROM tbl WHERE id>=$id)
UNION
(SELECT *,2 as q FROM tbl WHERE id<$id)
ORDER BY q, id;

Answer 2

try

$id=5;
SELECT * FROM tbl WHERE id>=$id
union
SELECT * FROM tbl WHERE id<$id ;

Answer 3

you want all rows? if the order is what you are looking for, sort your result set:

SELECT * FROM tbl
ORDER BY id >= $id DESC, id ASC

Answer 4

Try something like this...

SELECT *, (IF(id<5, true,false)) AS ltfive
FROM mytable
ORDER BY ltfive, id