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-sensitive alternative for ILIKE.
   
 
   
 
 
 
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.