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() |
|
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() |
|
SOUNDEX() |
|
SUBSTR() |
|
SUBSTRING_INDEX() |
|
SUBSTRING() |
|