Substring functions in mySQL

[wally . randall]

How can I extract a middle segment of text in mySQL.  For example a column contains 
this string: 'William Walker Jones'.  I need to split this into the first, middle, and 
last names.  I can easily extract the first and last names but how do I extract the 
Middle name?