Jason Howard, Tom Albert, Sam Smith

select * from directory order by name

ORDER BY SUBSTRING_INDEX(name, ' ', -1)