Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Can you help me with a query to separate name into two columns firstname, lastname?

Can you help me with a query to separate name into two columns firstname, lastname?

Thread began 1/06/2023 6:23 am by jo271221 | Last modified 1/06/2023 1:29 pm by Ray Borduin | 261 views | 3 replies |

1/06/2023 6:23 am | #1 jo271221

Can you help me with a query to separate name into two columns firstname, lastname?

So from one column = name i
to two columns firstname, lastname

1/06/2023 10:55 am | #2 Ray BorduinWebAssist

UPDATE Table
SET
FirstName = SUBSTRING_INDEX(FullName, ' ', 1),
LastName = SUBSTRING_INDEX(FullName, ' ', -1)

Did this help? Tips are appreciated...

1/06/2023 11:10 am | #3 jo271221

Thank you!
and then if there is a middle name example Mary Beth Olson OR is this accomplished more efficiently in a comma delimited text file or another method?

1/06/2023 1:29 pm | #4 Ray BorduinWebAssist

If there is a middle name then it would be included in the last name with this script. You could probably remove the middle name with a script that checks if there is a space in the last name.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.