I have a table with a column for regular price and a column for special price. I need to sort by the lowest price.
If a particular record contains a special price sorting should use this price instead of the regular price.
Basically I have to ignore the regular price if a special price is not 0.00.
Can I do this in SQL [MySQL 4.012]?
If so, how?