Name
trim — removes characters from both ends of string argument
Synopsis
trim
( |
str string , |
trimchars string
) ; |
Description
trim
returns a copy of subsequence
of string str with all the characters present in trimchars trimmed
off from the beginning. If the second argument is omitted, it is a
space ' ' by default.
rtrim
is similar except that it
trims from the right.
trim trims from both ends.
concat('*',trim(' SIMURG '),'*') -> '*SIMURG*' ltrim('AbracadabrA','bAr') -> 'acadabrA' rtrim('AbracadabrA','bAr') -> 'Abracada' trim('AbracadabrA','bAr') -> 'acada'