/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 votes333 views3 answers
Row number mysql
SQL
2 votes288 views1 answer
Sql find missing values between two tables
SQL
14 votes317 views4 answers
Remove record from table sql
SQL
0 vote306 views1 answer
Dump db only triggers mysql
SQL
5 votes314 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
2 votes325 views1 answer
Revokeprivileges mysql
SQL
1 vote300 views2 answers
Mysql: command not found
SQL
7 votes313 views2 answers
Show size database mysql
SQL
0 vote345 views1 answer
How to get button for every record from mysql
SQL
7 votes327 views3 answers
Postgresql dump and restore db
SQL