One-to-Many Count Parent’s Children in mySQL
So I have two tables. The first one contains a list of images that belong to a job, the second one contains all the different properties of each image. Parent […]
MySQL
Sorting characters and numbers in mySQL
So I have a table with a column in this form someColumn 1 A 2 C 3 10 When you ORDER BY someColumn you get result in this order 1,10,2,3,A,C […]
Delete expired entries in MYSQL
For those who want to delete items in a MySQL database based on a date field the process is very easy. First of all you need a DATE field, for […]
Efficient use of COUNT()
The other day I was trying to figure out how many records there were in my DB I found in a website that I needed to use COUNT(*). The example […]