mysql case (1)


sorting on two price fields in MySQL

Sorting on two price fields in MySQL was a confusing thought at first, and was tempted to query then use php to do it. No! I needed a way to select my products and order them by price. But we have two prices, a “price” and “price_offer”, so we need to compare these values so […]