By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
substr('../images/1-fkafjkdfj.jpg',11,length('../images/1-fkafjkdfj.jpg')-POSITION("-" IN '../images/1-fkafjkdfj.jpg')+5) |
---|
1-fkafjkdfj.jpg |
replace('aaa@test.com',substring('aaa@test.com',position('@' in 'aaa@test.com'), length('aaa@test.com')-position('@' in 'aaa@test.com')+1),'@other.net') |
---|
aaa@other.net |