/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

2 votes308 views1 answer
Import large .sql files into lampp
SQL
0 vote320 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote323 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
-1 vote337 views1 answer
Window functions in sql
SQL
1 vote315 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote311 views1 answer
Which MySQL data type to use for storing boolean values
SQL
15 votes335 views3 answers
Postgresql change column type
SQL
0 vote354 views2 answers
Postgres isnull
SQL
1 vote308 views1 answer
Oracle case
SQL
0 vote301 views1 answer
Automatically update database last seen datetime in sql
SQL