As applications are getting more complex and manipulating data in more complex ways it’s becoming more important to optimise our database queries to be as efficient as possible. This article shows how more explicit queries can reduce execution time and take some of the strain off system resources.

A quick guide to one of the most useful MySQL functions. The replace function is a great way to find and replace bulk text matches in one easy step.