SQL | Develop Websites

Posted by Barnaby Knowles on 5 March 2010, 11:25 pm

Usually our SQL queries use JOINs in SELECT queries. But what about if you want to DELETE using a JOIN? It’s not as straightforward.

SQL Query To Order By Surname When Name Is All One Field

Posted by Barnaby Knowles on 25 February 2010, 11:05 pm

Ever need to order an SQL query by the surname/last name of a user, but their full name is all one single field? Here’s how to use some of MySQL’s string function to do just that!