SELECT with Result Ordered by Minimum of Fields

[David T. Ashley]

Hi,

I have a table and I'd like to do a SELECT query with the result ordered by
the minimum of two fields.  I might also like to query by the minimum (but
that is an easier problem, as I can just rephrase it as an OR).

Can I just write something like:

SELECT * FROM mytable WHERE fieldofinterest<value ORDER BY MIN(field1,
field2) ASC;

or is it more complicated or impossible?

Thanks, Dave.