Hi, you could try:
SELECT name,
SUBSTRING_INDEX(name,' ', 1) as first,
SUBSTRING_INDEX(v2, ' ', -1) as last
FROM table
For the uppercase of the first letter, as i don't know a specific
functions to do that in MySQL (it has ucase and lcase but for all the
word), you must "play" wit
Hi all,
I think this can be done with a SQL query, but not have much luck getting it
right. Was hoping to get some suggestions on the best way to do this.
I need to extract the 'name' column in a mysql database table. split the name so
we have a "first" and "last" name value, as the name was or
