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.

Case Conversion

Regular Expression Matching

Alias for RLIKE.

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.

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