/SQL/Split first name and last name in sql

Split first name and last name in sql

# Name of table = names_table
# Name of column containing names = full_name
# Simply change the table and column name to what corresponds with your dataset

SELECT LEFT(full_name, STRPOS(primary_poc, ' ') -1 ) AS first_name,  
  		RIGHT(full_name, LENGTH(primary_poc) - STRPOS(primary_poc, ' ')) AS last_name, name
FROM names_table;

# NB: This does not capture middle names

Similar codes

0 vote295 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote308 views1 answer
Add a new column into table
SQL
0 vote287 views1 answer
Postgres drop type
SQL
1 vote296 views1 answer
Psql search table
SQL
0 vote304 views1 answer
Oracle swap partition
SQL
3 votes310 views1 answer
Sql print all names that start with a given letter
SQL
0 vote286 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote278 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote289 views1 answer
Mysql repair a table
SQL
8 votes297 views1 answer
How to check mysql version in xampp
SQL