How to get the first name from customer_name column

Question

selectsubstring(custommer_name,1,instr(custmer_name,''))asfirst_namefromsales.customers; this solution gave me the answer but it doesn't work for last name

P粉884548619 · Answer

Using SUBSTRING_INDEX()Requires 3 parameters:

Column name
Delimiter
The number of occurrences

You can find more instructions here Article

Inquire

SELECT
  SUBSTRING_INDEX(customer_name,' ', 1) as first_name, 
  SUBSTRING_INDEX(customer_name,' ', -1) as last_name FROM customer;

P粉276064178 · Answer

Please test it: I use the locate function to define the location of " ".

SELECT 
LEFT(customer_name, LOCATE(' ',customer_name)-1) as first_name,
RIGHT(customer_name, LENGTH(customer_name)-LOCATE(' ',customer_name)) as last_name
FROM customer;

Result set: