/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

7 votes183 views1 answer
Mysql iif
SQL
0 vote211 views1 answer
Postgres get database encoding
SQL
6 votes185 views2 answers
Drop foreign key
SQL
0 vote187 views1 answer
Delete hangfire retries list
SQL
3 votes178 views1 answer
Sql server version query
SQL
0 vote238 views3 answers
Characters found after end of sql statement
SQL
0 vote183 views1 answer
Flush user resource mysql
SQL
0 vote176 views1 answer
How to reset AI in sql
SQL
1 vote201 views5 answers
What is in operator in sql
SQL
0 vote197 views2 answers
How to check if sqlite table exists in nodejs
SQL