Sort by "last name" in MySQL when the "full name" has periods in it

Question

I found this excellent little conditional order that sorts strings like "First Last" nicely, even correctly handling "First Van Damn".

"SUBSTRING(p.name, LOCATE(' ', p.name) +1)

Now I have names like "Alfred E. Newman" and want the sorting to work correctly for that name (that is, it does not end under E).

Any help would be greatly appreciated.

Answer 1

If you really want to do this, how about

RIGHT(p.name, LOCATE(' ', REVERSE(p.name)) - 1)

Answer 2

, . , , P, N?

- , . , : ( ) : FirstName, MiddleInitial, LastName.