/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 vote157 views1 answer
Dasebase_url-postgres for windows
SQL
0 vote173 views1 answer
Turnicate in mysql
SQL
1 vote179 views2 answers
Mysql allow remote connections
SQL
0 vote180 views1 answer
Unique element in sql
SQL
0 vote164 views1 answer
Initcap in sql
SQL
5 votes133 views1 answer
Copy table from one database to another mysql
SQL
4 votes175 views1 answer
Oracle delete last row
SQL
9 votes156 views3 answers
Sequence postgresql
SQL
0 vote125 views1 answer
Import sql file in mysql linux
SQL
0 vote180 views1 answer
Oracle table privileges
SQL