/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

1 vote271 views2 answers
Sql example query
SQL
10 votes262 views2 answers
Sql merge statement
SQL
0 vote283 views1 answer
Alter check command
SQL
0 vote270 views1 answer
Retornar apenas o ano mysql date
SQL
7 votes256 views1 answer
Query delete duplicates
SQL
5 votes289 views3 answers
Postgres show databases
SQL
0 vote272 views1 answer
Liquibase update row
SQL
7 votes284 views1 answer
Xampp reset mysql
SQL
0 vote261 views1 answer
Resulting Query
SQL
2 votes270 views1 answer
Sql alchemy or
SQL