sql - MySQL's equivalent of Oracle Rtrim? -
i trying have in mysql same effect of oracle's rtrim
.
oracle> rtrim('tech6372', '0123456789') result: 'tech'
as can see oracle regards sec parameter list of characters removed, not substring removed.
this different next in mysql:
mysql> select trim(trailing 'xyz' 'barxxyz'); result: 'barx'
is there neat way mysql same thing oracle here?
mysql sql oracle
No comments:
Post a Comment