'Is there a function in sql that separates strings in a column to three different columns?

This is my first question in this community. I am learning how to use these technical tools for analysis with the google data analytics course. I have learnt how to separate strings in a column on a google spreadsheet but have not tried it on SQL, not particularly familiar with SQL as i am just leaning an a beginner. I tried to write the query using the SPLIT function like this

SELECT
 name
FROM 
 `my-project-for-course-4-week-2.customer_data.customer_address`
SPLIT (name, " ")

My goal is to divide the customer names from the name column into two columns to have first name and last names in different columns

sqlfunction


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions