string operations mysql code example

Example: mysql string function

MySQL String Functions
ASCII
SUBSTRING
ORD
MID
CONV
SUBSTRING_INDEX
BIN
LTRIM
OCT
RTRIM
HEX
TRIM
CHAR
SOUNDEX
CONCAT
SPACE
CONCAT_WS
REPLACE
LENGTH
REPEAT
CHAR_LENGTH
REVERSE
BIT_LENGTH
INSERT
LOCATE
ELT
INSTR
FIELD
LPAD
LCASE
RPAD
UCASE
LEFT
LOAD_FILE
RIGHT
QUOTE