String Functions and Operators¶
See also
Summary of Functions¶
‘TODO’ descriptions ‘TODO’ “regular functions” …there are no regular or irregular functions!!!
Comparative and regular functions¶
Operator |
Description |
|---|---|
LIKE |
|
NOT LIKE |
|
STRCMP() |
|
NOT REGEXP |
|
REGEXP |
|
RLIKE |
Conversion and translation functions¶
Operator |
Description |
|---|---|
ASCII() |
|
BIN() |
|
CHAR() |
|
HEX() |
|
LOWER() |
|
LCASE() |
|
UCASE() |
|
UNHEX() |
|
UPPER() |
Length and size functions¶
Operator |
Description |
|---|---|
BIT_LENGTH() |
|
CHAR_LENGTH() |
|
LENGTH() |
|
OCTET_LENGTH() |
Formatting and modification functions¶
Operator |
Description |
|---|---|
CONCAT() |
|
TRIM() |
|
LTRIM() |
|
RTRIM() |
Position functions¶
Operator |
Description |
|---|---|
FIELD() |
|
FIND_IN_SET() |
|
INSTR() |
|
LEFT() |
|
INSERT() |
|
LOCATE() |
|
POSITION() |
Other string functions¶
Operator |
Description |
|---|---|
ELT() |
|
EXPORT_SET() |
|
FORMAT() |
|
LOAD_FILE() |
|
LPAD() |
|
MAKE_SET() |
|
MATCH |
|
MID() |
|
ORD() |
|
QUOTE() |
|
REPEAT() |
|
REPLACE() |
|
REVERSE() |
|
RIGHT() |
|
RPAD() |
|
SUBSTR() |
|
SUBSTRING_INDEX() |
|
SUBSTRING() |
