FROM_BASE64
Takes a base-64 encoded string and returns the decoded result as a binary string.
The result is NULL if the argument is NULL or an invalid base-64 string.
Syntax
FROM_BASE64 (str)
Arguments
str
: a base-64 encoded string
Return Type
Binary string (blob)
Examples
SELECT TO_BASE64('abracadabra'), FROM_BASE64(TO_BASE64('abracadabra')); **** +--------------------------+---------------------------------------+ | TO_BASE64('abracadabra') | FROM_BASE64(to_base64('abracadabra')) | +--------------------------+---------------------------------------+ | YWJyYWNhZGFicmE= | abracadabra | +--------------------------+---------------------------------------+