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.