mysql name column split into 2 columns

its_me_dev answered on December 21, 2023 Popularity 3/10 Helpfulness 2/10

answer mysql name column split into 2 columns

mysql name column split into 2 columns

Comment

//for name column => John Doe or John
SELECT 
TRIM(SUBSTRING_INDEX(name, ' ', 1)) AS firstname, 
  TRIM(SUBSTRING(name, LENGTH(SUBSTRING_INDEX(name, ' ', 1))+2, LENGTH(name))) AS lastname FROM tbl_user;
  
  UPDATE `tbl_user`
SET
  `first_name` = TRIM(SUBSTRING_INDEX(name, ' ', 1)),
  `last_name` = TRIM(SUBSTRING(name, LENGTH(SUBSTRING_INDEX(name, ' ', 1))+2, LENGTH(name))) where id > 0;
  
 // It also works with middle names. The middle name will be added to the first name.
SELECT 
TRIM(SUBSTRING(name,1, LENGTH(name)- LENGTH(SUBSTRING_INDEX(name, ' ', -1)))) AS firstname, 
SUBSTRING_INDEX(name, ' ', -1) AS lastname

Popularity 3/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: mysql sql

Link to this answer
Share Copy Link

Contributed on Dec 21 2023

its_me_dev

0 Answers Avg Quality 2/10

mysql name column split into 2 columns

Contents

More Related Answers

mysql name column split into 2 columns

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.