mysql: substring that returns the first occurrence from the right? (subrstring?!)

Asked 2010-01-13T12:26:25.387

is there a way to return the first occurrence of a space from the right side of the string in sql?

mysql