String & binary functions¶

This family of functions perform operations on a string input value, or binary input value (for certain functions), and return a string or numeric value.

The functions are grouped by type of operation performed.

Function Name

Binary Input Supported

Collation Supported

Notes

General Manipulation

✔

✔

✔

✔

✔

✔

✔

✔

✔

✔

✔

✔

Provides partial support for collation. For details, see the documentation of the function.

Full-Text Search

Case Conversion

Regular Expression Matching

Alias for RLIKE.

Alias for REGEXP_SUBSTR_ALL.

Alias for RLIKE.

Other Matching/Comparison

✔

✔

Alias for POSITION. Provides partial support for collation. For details, see the documentation of the POSITION function.

✔

✔

Provides partial support for collation. For details, see the documentation of the function.

✔

✔

Provides partial support for collation. For details, see the documentation of the function.

Case-insensitive alternative for LIKE.

Case-insensitive alternative for LIKE ANY.

✔

✔

✔

✔

Provides partial support for collation. For details, see the documentation of the function.

✔

✔

✔

✔

Provides partial support for collation. For details, see the documentation of the function.

✔

✔

Compression/Decompression

✔

✔

✔

Encoding/Decoding

✔

✔

Error-handling version of BASE64_DECODE_BINARY.

Error-handling version of BASE64_DECODE_STRING.

Error-handling version of HEX_DECODE_BINARY.

Error-handling version of HEX_DECODE_STRING.

Cryptographic/Checksum

Intended primarily for checksum operations. Not recommended for cryptography.

Intended primarily for checksum operations. Not recommended for cryptography.

Intended primarily for checksum operations. Not recommended for cryptography.

Intended primarily for checksum operations. Not recommended for cryptography.

Hash (Non-cryptographic)

✔

Allows data types other than string and binary. Not intended for cryptography.

✔

Allows data types other than string and binary. Not intended for cryptography.

Collation

Large Language Model