Updated on 2024-11-11 GMT+08:00

String Functions

Table 1 String functions

MySQL

Support Unplanned ALT (Yes/No)

ASCII()

Supported

BIT_LENGTH()

Supported

CHAR_LENGTH()

Supported

CHARACTER_LENGTH()

Supported

CONCAT()

Supported

CONCAT_WS()

Supported

HEX()

Supported

LENGTH()

Supported

LPAD()

Supported

MD5()

Supported

RANDOM_BYTES()

Supported

REPEAT()

Supported

REPLACE()

Supported

RPAD()

Supported

SHA()/SHA1()

Supported

SHA2()

Supported

SPACE()

Supported

STRCMP()

Supported

FIND_IN_SET()

Supported

LCASE()

Supported

LEFT()

Supported

LOWER()

Supported

LTRIM()

Supported

REVERSE()

Supported

RIGHT()

Supported

RTRIM()

Supported

SUBSTR()

Supported

SUBSTRING()

Supported

SUBSTRING_INDEX()

Supported

TRIM()

Supported

UCASE()

Supported

UPPER()

Supported

UNHEX()

Supported

FIELD()

Supported

COMPRESS()

Supported

UNCOMPRESS()

Supported

UNCOMPRESS_LENGTH()

Supported

EXPORT_SET()

Supported

POSITION()

Supported

LOCATE()

Supported

CHAR()

Supported

ELT()

Supported

FORMAT()

Supported

BIN()

Supported

MAKE_SET()

Supported

TO_BASE64()

Supported

FROM_BASE64()

Supported

ORD()

Supported

MID()

Supported

QUOTE()

Supported

INSERT()

Supported

INSTR()

Supported