Thursday, 15 August 2013

sql - MySQL's equivalent of Oracle Rtrim? -



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