/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 vote113 views1 answer
Duplicating a MySQL table with all the data Command
SQL
1 vote115 views2 answers
Grab part of a string sql
SQL
13 votes124 views1 answer
Select count of distinct values sql
SQL
14 votes136 views6 answers
Finding duplicate rows mysql
SQL
2 votes114 views1 answer
SQL column name Postgre
SQL
0 vote125 views1 answer
Check if string is a number sql
SQL
0 vote124 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote103 views1 answer
Sql examples from your work
SQL
1 vote188 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
1 vote110 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL