/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 vote106 views1 answer
Select * from mysql.proc
SQL
24 votes105 views6 answers
Sql change table name
SQL
0 vote102 views1 answer
Selects all the columns from the sailors table
SQL
10 votes119 views2 answers
Select nextval from sequence oracle
SQL
0 vote102 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
1 vote94 views1 answer
Mysql select and count left join
SQL
0 vote98 views1 answer
Like sql for second letter of the family name
SQL
6 votes137 views3 answers
Mysql change auto_increment start value
SQL
0 vote105 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote119 views1 answer
Space not removing from column in sql
SQL