SQLUpdate two column field by Splitting the value from one column in SQL December 5, 2017 Chandan SharmaComment on Update two column field by Splitting the value from one column in SQLUpdate two column field by Splitting the value from one column in SQL QUERY:QUERY: UPDATE user u2 set u2.first_name = SUBSTRING_INDEX(u2.name, ' ', 1), u2.last_name = SUBSTRING_INDEX(u2.name, ' ', -1) Share this:FacebookX