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

Notes

General Manipulation

Case Conversion

Regular Expression Matching

Alias for RLIKE.

Alias for RLIKE.

Other Matching/Comparison

Alias for POSITION.

Case-insensitive alternative for LIKE.

Case-insensitive alternative for LIKE ANY.

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