/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 vote104 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote114 views1 answer
Modifier une valeur sql
SQL
0 vote112 views1 answer
Mysql récupérer le code création de vue
SQL
14 votes155 views1 answer
How to export db from mysql
SQL
0 vote104 views1 answer
List all permissions on a table in postgres
SQL
0 vote111 views1 answer
Oracle INTERVAL DAY to second to number
SQL
5 votes108 views3 answers
Day of week postgresql
SQL
7 votes116 views3 answers
Foreign key oracle
SQL
3 votes113 views1 answer
Oracle apex call duration
SQL
0 vote109 views1 answer
Liquibase update row
SQL