Module string 

Functions

concat

CONCAT(str1, str2, …) - Concatenate strings

concat_ws

CONCAT_WS(separator, str1, str2, …) - Concatenate with separator

left

LEFT(str, len) - Return leftmost characters

length

LENGTH(str) / CHAR_LENGTH(str) - String length

lower

LOWER(str) / LCASE(str) - Convert to lowercase

lpad

LPAD(str, len, pad) - Pad left side

ltrim

LTRIM(str) - Remove leading whitespace

position

POSITION(substr IN str) / INSTR(str, substr)

repeat

REPEAT(str, count) - Repeat string n times

replace

REPLACE(str, from, to) - Replace all occurrences

reverse

REVERSE(str) - Reverse string

right

RIGHT(str, len) - Return rightmost characters

rpad

RPAD(str, len, pad) - Pad right side

rtrim

RTRIM(str) - Remove trailing whitespace

space

SPACE(count) - Return string of spaces

substr

SUBSTR(str, pos, [len]) / SUBSTRING(str, pos, [len])

trim

TRIM(str) - Remove leading/trailing whitespace

upper

UPPER(str) / UCASE(str) - Convert to uppercase