MySQL – Conditional Joins

For the most part I’ve used many JOINs in my queries since I leartn how to use them and what they were good for, I much prefer to use an Inner Join over the the Implied join of a WHERE statement. For those who haven’t yet learnt about JOINs you might be using an implied […]

MySQL – Conditional Updates

Just a quick blog post in an update related way, Recently i’ve needed to toggle multiple rows in a database from 1 value to 1 of possible 2 values dependant on the contents of a field on the row. I wasn’t sure if this was possible, so i asked in #PHPWomen IRC Channel and the […]