A case for CASE in your SQL

I’m going to add more to this later, but for now… SQL CASE scenario #1 Ever wanted to offer quantity discounts for shoppers? Here’s an example of a trivial implementation of the CASE condition in MySQL to get the job done. mysql> SET @cart_quantity := 3; Query OK, 0 rows affected (0.00 sec) mysql> select [...]