I guess that would depend on what you consider a "last name" or a "middle 
name"

A typical "western" name has 3 parts, like your example. However there are 
many names like "van der Plaats" or "de la Hoya" that are not so easy to 
detect based simply on what space to split the name at.

What about people with more than 1 middle name?  Nearly all of my kids 
have 2 middle names (one derived somehow from their grandparents, the 
other just sounded good.) So with a name like "Jeremy Alexander Martin von 
Schleffler" (not a real name as far as I know) Where do the middle names 
end and where does the last name begin?

Any way, extracting substrings: use the SUBSTRING() function. That is, 
once you decide where you want to split the string..... ;-)

All of the MySQL string functions are documented here:

http://dev.mysql.com/doc/mysql/en/String_functions.html


Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine




[EMAIL PROTECTED] wrote on 09/08/2004 09:35:07 AM:

> 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?

Reply via email to