Stuff that was so important, I had to write it down.
sql
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 [...]
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 to [...]
© 2009 Random Randy Ramblings. 
