Filter by Last Name

filter-by-name.php

/**
 * Filters posts by last word in title
 * 
 * Particularly useful for sorting staff lists by last name alphabetically
**/

function posts_orderby_lastname ($orderby_statement) {
	$orderby_statement = "RIGHT(post_title, LOCATE(' ', REVERSE(post_title)) - 1) ASC";
	return $orderby_statement;
}

// Your Loop

remove_filter( 'posts_orderby' , 'posts_orderby_lastname' );