/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 vote246 views1 answer
Object of class mysqli_result could not be converted to string
SQL
2 votes238 views2 answers
Sql query to list all tables in a database sql server
SQL
-2 votes230 views1 answer
Create trigger syntax
SQL
3 votes234 views2 answers
Brew start mysql
SQL
2 votes260 views3 answers
How to check current user in mySQL
SQL
11 votes256 views2 answers
Oracle saurce code
SQL
13 votes242 views2 answers
Get date from now() mysql
SQL
4 votes230 views3 answers
Mysql varchar length
SQL
0 vote253 views1 answer
Sql select column name like from multiple tables
SQL
10 votes245 views5 answers
Mysql create user
SQL