Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
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.
FROM_BASE64 (str)
str
: a base-64 encoded stringBinary string (blob)
SELECT TO_BASE64('abracadabra'), FROM_BASE64(TO_BASE64('abracadabra'));
+--------------------------+---------------------------------------+
| TO_BASE64('abracadabra') | FROM_BASE64(to_base64('abracadabra')) |
+--------------------------+---------------------------------------+
| YWJyYWNhZGFicmE= | abracadabra |
+--------------------------+---------------------------------------+