lundi 21 août 2017

MySQL: Where price < 50, sum(price +14)

I'm building a query that will automatically add shipping charges to an items price if it is less than $50, and another, higher, shipping charge if it has a raw price of more than 50. I've done some experimenting with CASE, IF, and SUM but I'm not sure which is the one I need.

Please help :(

Aucun commentaire:

Enregistrer un commentaire