> Say I wish to do a SELECT query and sort on a text column, but I want to pick
> two or three (or however many) specific values, designated by constant string
> values, to sort to the top. Can this be done with standard SQL?
>
> If you get what I'm talking about, it might be something like:
>
> ORDER BY textfield 'joe' 'dave' ASC
SELECT
textfield,
CASE
WHEN textfield = 'Joe' THEN TRUE
WHEN textfield = 'Dave' THEN TRUE
WHEN textfield = 'Jim' THEN TRUE
ELSE FALSE
END AS sortFirst
FROM
table
ORDER BY
sortFirst,
textfield
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
