Using SQL I need to parse name from column and make new columns out of it

Question

I have a column in SQL that has a name and various other items in it. I'm trying to figure out how to parse the name out and create new columns for it. I want to add two new columns and the new columns would then have first name and last name.

Example

APPLES-JST-JN-2022-07-22:BANANA:MELISSA:CUMBERBACH

Use SUBSTRING_INDEX() to extract parts of a delimited string. — Barmar
– Barmar, Commented Aug 5, 2022 at 22:13

Barmar · Accepted Answer · 2022-08-05 22:16:58Z

1

Use SUBSTRING_INDEX() to extract parts of a string that use a delimiter to separate values.

ALTER TABLE yourTable ADD FirstName VARCHAR(100), ADD LastName VARCHAR(100);

UPDATE yourTable 
SET FirstName = SUBSTRING_INDEX(SUBSTRING_INDEX(yourColumn, ':', -2), ':', 1),
    LastName = SUBSTRING_INDEX(yourColumn, ':', -1);

Replace yourTable and yourColumn with the actual table and column names.

answered Aug 5, 2022 at 22:16

Barmar

789k57 gold badges555 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using SQL I need to parse name from column and make new columns out of it

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related