显示表中的所有行，但首先显示id = x - PHP和MySQL

Question

I am new to PHP and MySQL. I wanted to know that if its possible to show all the rows from the table but first where id='some value'. ie.

SELECT * FROM users ORDER BY id='some value'

Thanks for answering.

Answer 1

You can make a set of queries, for example:

SELECT * FROM users WHERE id= 5 UNION SELECT * FROM users WHERE id != 5;

Or if you need something like this example:

SELECT * FROM users WHERE id >= 5;