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 @cart_quantity;
+—————-+
| @cart_quantity |
+—————-+
| [...]

How to - LIKE - use prepared statements

I was going to do the whole Valley Girl theme for this post, but decided that was lame.
So while converting an internal application query into a user-input web query when I stumbled across a problem. My prepared statement was not throwing an error and not giving me results. It took me a while [...]