Aaron Parecki

#mysql

• MySQL :: MySQL 5.0 Reference Manual :: 7.4.4 How MySQL Uses Indexes (dev.mysql.com)

  #databases #indexes #mysql #performance

  Sat, May 29, 2010 10:55am -07:00

• Sorting a query in MySQL ignoring the word "The"

  When you have a database of books or movies, some of the titles begin with "The." If you do a regular ORDER BY on the table, all the titles that start with "the" get clumped together. One option is running an unsorted query and sorting in PHP, but it would be better to sort at the database level. Here is a query I came up with to do that, using an IF function in MySQL!

  continue reading...

  #code #database #MySQL #sorting #SQL

  Sat, Apr 19, 2008 9:50pm -07:00
• The Guide To Understanding mysqlreport (hackmysql.com)

  #linux #mysql #performance #webdesign

  Wed, Sep 12, 2007 10:37am -07:00

• Virtual Users with Postfix and MySQL

  I recently discovered an excellent tutorial on setting up Postfix and Courier to use virtual users read from a MySQL database. This caught my attention because it is a much better setup than having real system users for all email addresses, as it allows much more flexibility. I finally set aside some time to set up a real mail server.

  continue reading...

  #mail server #MySQL #postfix

  Mon, Dec 25, 2006 7:01am -08:00