/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 vote125 views1 answer
Get last updated row sql server
SQL
11 votes122 views1 answer
How to get ddl for materialized view
SQL
1 vote133 views2 answers
Sql now - 1 day
SQL
4 votes127 views2 answers
Installing sql on ubuntu
SQL
0 vote130 views1 answer
Mysql remove bad character from all fields
SQL
0 vote119 views1 answer
Sql server user permissions and roles
SQL
0 vote124 views1 answer
Join in update query in mysql
SQL
4 votes115 views2 answers
Mysql how to change default charset
SQL
0 vote125 views1 answer
Mysql root permission denied lost
SQL
2 votes119 views2 answers
Postgres trigger insert into another table
SQL