/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 vote301 views2 answers
Installing mysql on centos 7
SQL
3 votes304 views2 answers
@sqlresultsetmapping
SQL
24 votes289 views4 answers
Mysql datetime
SQL
0 vote272 views3 answers
Group_concat sql server
SQL
0 vote300 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote278 views1 answer
Sql count total by foreign key
SQL
0 vote282 views1 answer
Mysql count unique in group statement
SQL
0 vote292 views1 answer
Tsql delete all rows
SQL
15 votes284 views1 answer
Mysql int range
SQL
0 vote294 views1 answer
Oracle sql add column auto generated value
SQL