String Functions and Operators

See also

Summary of Functions

• Comparative Functions
  • LIKE
  • REGEX
  • REGEXP
  • STRCMP
• Conversion Functions
  • ASCII
  • BIN
  • CHAR
  • HEX
  • UNHEX
  • LOWER
  • LCASE
  • UCASE
  • UPPER
• Length and Size Functions
  • CHAR_LENGTH
  • CHARACTER_LENGTH
  • LENGTH
  • OCTET_LENGTH
• String Modification Functions
• Position Functions
• Other String Functions
  • COERCIBILITY
  • ELT
  • EXPORT_SET
  • FORMAT
  • LOAD_FILE
  • LPAD
  • MAKE_SET
  • MATCH
  • MID
  • QUOTE
  • REPEAT
  • REPLACE
  • REVERSE
  • RIGHT
  • RPAD
  • SOUNDEX
  • SUBSTR
  • SUBSTRING
  • SUBSTRING_INDEX

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()