Re: Lack of "real" example makes it very dificult to understand!

[Stefan Hinz]

V@no wrote:

> > PS - what's the question you've been trying
> > to get an answer for?

> Well, I couldnt find any solution for the task I'm
> trying to acomplish as discribed on this forum:
> http://forums.devshed.com/showthread.php?p=745159&;
> amp;posted=1

OK, so your question was: "is there any way select entries (sorted by whatever) but have one/two/three specific entries be always first in the list?"

As other users on devshed have pointed out, you could do that using one SQL query only, but that query would look pretty daunting. I'd suggest to use two queries instead, and assemble the results using PHP or whatever web programming language you are using. The queries would look like this (assuming 10, 20, and 30 are the message IDs that you would always want to retrieve:

SELECT messageID, ... FROM tbl WHERE messageID IN(10,20,30)

SELECT messageID, ... FROM tbl ... ORDER BY sortField (ASC | DESC)

Stefan Hinz, MySQL Documentation, Berlin, Germany