Substring functions in mySQL

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?

Report query problem

Coming from an Oracle background I am struggling with the following report generation. This is a report which needs to be created using mySQL: Week of mm/dd/yy mm/dd/yy mm/dd/yy mm/dd/yy mm/dd/yy Total All Groups nn nn nn nn