How to get part of a string from a column in Database and put in another column of same database

How to get part of a string from a column in Database and put in another column of same database.
I need abc from “abc/def/hijk”

@subashini You can do by using split function after spliting store in one variable than pass that variable in new column name