David T. Ashley wrote:
Can I just write something like:
SELECT * FROM mytable WHERE fieldofinterest<value ORDER BY MIN(field1,
field2) ASC;
I think this will work..
SELECT *, IF(a-b < 0,a, b) as SortField
FROM table
WHERE whatever
ORDER BY SortField
a and b being the names of the fields you are interested in.
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzone.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]