By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| str | str | result |
|---|---|---|
| abc.123.vet@xyz.com | abc.123.vet | vet |
| aaa@yy.com | aaa | aaa |
| aaa bte@yy.com | aaa bte | bte |
| str | str | result |
|---|---|---|
| abc.123.vet@xyz.com | abc.123.vet | vet |
| aaa@yy.com | aaa | aaa |
| aaa bte@yy.com | aaa bte | bte |