FROM_BASE64()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns the decoded value as binary string of a base-64 encoded string.
USAGE
FROM_BASE64(string)
Argument Name | Description |
|---|---|
| The base-64 value that is to be decoded |
DETAILS
FROM_BASE64() is a string function that returns the decoded value of a base64-encoded string.
A NULL is returned if the argument is NULL or is otherwise not a valid base-64 string.
For the opposite conversion, see TO_
EXAMPLES
SELECT FROM_BASE64('abc');
+--------------------+
| FROM_BASE64('abc') |
+--------------------+
| NULL |
+--------------------+
SELECT FROM_BASE64(TO_BASE64('MariaDB'));
+-----------------------------------+
| FROM_BASE64(TO_BASE64('MariaDB')) |
+-----------------------------------+
| MariaDB |
+-----------------------------------+