Re: Query result - not to be sorted asc or desc

[Klaus Posenauer]

The problem is that the various locations can be in a different order the next time around. I'm using this database as a repository for tourcommentaries for those various locations and need them sorted according to the tourroute.

So the query would have to be something like

SELECT l.notes FROM locations l
WHERE l.location = d or l.location = a or l.location = c or l.location = b
ORDER BY (something that expresses - above locations in reverse order)