Order By Subquery

[Pawn]

Hiya. I have a statement similar to:

 

SELECT * FROM posts WHERE post_id NOT IN('121 84 376 20 3 94 1');

 

I'd like the "excluded" posts to be returned at the end of the results set, rather than skipped.

 

Pseudo code:

 

SELECT excluded = IN('121 84 376 20 3 94 1') ? 1 : 0
ORDER BY excluded ASC

 

Any pointers much appreciated.

[awjudd]

Would something like this work?

 

SELECT ( post_id IN ( 121, 84, 376, 20, 3, 94, 1 ) ) AS excluded FROM posts

 

~judda

[Pawn]

Bingo! Nicely done.