Update two column field by Splitting the value from one column in SQL

Update two column field by Splitting the value from one column in SQL:

QUERY:


UPDATE user u2
set
u2.first_name = SUBSTRING_INDEX(u2.name, ' ', 1),
u2.last_name = SUBSTRING_INDEX(u2.name, ' ', -1)