String Functions and Operators

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