MySQL question - using IN()

[Spidah]

Whey you use the IN() option in a mysql query is it possible to have the
records selected in the order in which they appear in the IN string?

Thanks

Hamilton

[Simon Stienen]

Spidah <h.*********@eggstra.co.nz> wrote:

Whey you use the IN() option in a mysql query is it possible to have the
records selected in the order in which they appear in the IN string?

Thanks

Hamilton

<http://dev.mysql.com/doc/mysql/en/String_functions.html>:
FIELD() or FIND_IN_SET()
--
Simon Stienen <http://dangerouscat.net> <http://slashlife.de>
»What you do in this world is a matter of no consequence,
The question is, what can you make people believe that you have done.«
-- Sherlock Holmes in "A Study in Scarlet" by Sir Arthur Conan Doyle

[Mike Edenfield]

Spidah wrote:

Whey you use the IN() option in a mysql query is it possible to have the
records selected in the order in which they appear in the IN string?

Something like this should work:

SELECT ...
FROM ...
WHERE Field IN (x,y,z)
ORDER BY CASE Field
WHEN x THEN 1
WHEN y THEN 2
WHEN z THEN 3
END

--Mike