By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table bal(Perevod varchar(40))
✓
insert into bal values('aaa/dddd')
✓
UPDATE bal
SET Perevod = substr(Perevod, 1, INSTR(Perevod, '/')-1)
WHERE INSTR(Perevod, '/')>0;
✓
select *
from bal
Perevod |
---|
aaa |