FROM_BASE64()
Function Description
FROM_BASE64() is used to convert a Base64 encoded string back to raw binary data (or text data). Data that is Base64 encoded using the TO_BASE64() function can be decoded. If the argument is NULL, the result is NULL.
Function syntax
> FROM_BASE64(str)
Parameter interpretation
| Parameters | Description |
|---|---|
| str | Required parameters. Base64 encoded string to convert. |
Examples
```SQL mysql> select from_base64('MjU1'); +-------------------+ | from_base64(MjU1) | +-------------------+ | 255 | +-------------------+ 1 row in set (0.00 sec)
mysql> SELECT TO_BASE64('abc'), FROM_BASE64(TO_BASE64('abc')); +----------------+-----------------------------+ | to_base64(abc) | from_base64(to_base64(abc)) | +----------------+-----------------------------+ | YWJj | abc | +----------------+-----------------------------+ 1 row in set (0.00 sec)
mysql> select from_base64(null); +-------------------+ | from_base64(null) | +-------------------+ | NULL | +-------------------+ 1 row in set (0.01 sec) ```