from_base64

description

Syntax

VARCHAR from_base64(VARCHAR str)

返回对输入的字符串进行Base64解码后的结果，当输入字符串不正确时（出现非Base64编码后可能出现的字符）将会返回NULL

example

mysql> select from_base64('MQ==');
+---------------------+
| from_base64('MQ==') |
+---------------------+
| 1                   |
+---------------------+
mysql> select from_base64('MjM0');
+---------------------+
| from_base64('MjM0') |
+---------------------+
| 234                 |
+---------------------+

keywords

from_base64