Sort by Surname7 Jun 2011ORDER BY SUBSTRING_INDEX(full_name, ' ', -1)Markdown · Copy as MarkdownRicky Moorhouse