<blockquote> Possible Duplicate: MySQL Query to pull items, but always show a certain one at the top </blockquote> Hi I have a number of items in a database table. At the moments they're sorted by name. But I have one item with ID 12 which I would like to always be first in the line. Is this possible in an easy way?

You can do <pre class="prettyprint"><code>ORDER BY (id = 12) DESC, someOtherColumn </code></pre> This will order by whether <code>id</code> equals <code>12</code> first (resulting in either <code>0</code> or <code>1</code>, hence the DESC to put the positive results first), then any other column(s) you may specify for sorting.

Force to order a certain item first [duplicate]

1 Answers

You can do

ORDER BY (id = 12) DESC, someOtherColumn

This will order by whether id equals 12 first (resulting in either 0 or 1, hence the DESC to put the positive results first), then any other column(s) you may specify for sorting.