[SOLVED] sort everything but 1 result

[chick3n]

Is it possible to re-make a query so that it would order the results by name alphabetically, except 1 result that i want to be returned first, and that 1 result is dynamic so it cannot be hard coded.

[cooldude832]

Not that I know of but you could use and IF statement with CONCAT and add characters to the front of a string to force it to be first in the sorting

example

select 
ColID,
IF(ColID = CRITERIA TO BE #1,CONCAT('AAAAAAAAAAAA_',Colname),Colname) as SortField
from `table1`
ORDER BY SortField

Then using php or whatever strip the AAAAAAAAAAA_ from it if its the first row in the while($row = fetch)

[fenway]

You can also do this in the ORDER BY clause directly...