MySQL String

lpad
Returns "string_expression1" padded to length "integer_expression" with occurrences of "string_expression2". If "string_expression1" is longer than "integer_expression", the appropriate portion of "string_expression1" is returned.
ltrim
Returns "string_expression1", with leading characters removed up to the first character not in "string_expression2"; for example, ltrim ( 'xyxXxyAB' , 'xy' ) returns XxyAB.
hex
Returns the hexadecimal string representation of "numeric_expression1".
repeat
Returns the "string_expression" repeated "numeric_expression1" times.
replace
Returns "string_expression" having replaced "string_expression2" with "string_expression3".
reverse
Returns "string_expression" reversed.
right
Returns the rightmost "numeric_expression" characters from "string_expression1".
rpad
Returns "string_expression1" right-padded to length "integer_expression" with occurrences of "string_expression2". If "string_expression1" is longer than "integer_expression", the appropriate portion of "string_expression1" is returned. If "string_expression2" is not specified, then spaces are used.
rtrim
Returns "string_expression1", with final characters removed after the last character not in "string_expression2"; for example, rtrim ( 'ABxXxyx' , 'xy' ) returns ABxX. If "string_expression2" is not specified, the final space characters are removed.
soundex
Returns a soundex string of "string_expression1".

Parent topic: MySQL