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?

View all replies to this thread

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 jo271221 | 370 views | 3 replies

1/06/2023 10:55 amRay BorduinWebAssist

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

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.

Want your website pre-built and hosted?

Begin selling online quickly with Cafe Commerce.

Everything else!

►
Text Formatting
- Bold
- Italics
- Underline
- Highlight
- Color
- Size
- Font
►
Insert Element
- Image
- List
- Attachment
►
Insert Link
- Email
- URL
- To Post
- To Thread
►
Block Formatting
- Code
- Note
- Quote
- PHP
- HTML
- Indent
- Ignore Format
Cancel

Uploading file...

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

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

1/06/2023 10:55 amRay BorduinWebAssist

Build websites with a little help from your friends

Build websites from already-built web applications

Want your website pre-built and hosted?

Everything else!

U.S. 858.201.4911 | International +1.858.201.4911

We've earned your trust.

Connect with us.

Post a question as

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

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

1/06/2023 10:55 amRay BorduinWebAssist

Build websites with a little help from your friends

Build websites from already-built web applications

Want your website pre-built and hosted?

Everything else!

U.S. 858.201.4911 | International +1.858.201.4911

We've earned your trust.

Connect with us.

Rate your experience or provide feedback on this page

We were unable to retrieve the attached file

Post a question as

Attach and remove files

Enter the URL you would like to link to in your post

This is how you use right click RTF editing