from_base64

description

Syntax

VARCHAR from_base64(VARCHAR str)

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

example

  1. mysql> select from_base64('MQ==');
  2. +---------------------+
  3. | from_base64('MQ==') |
  4. +---------------------+
  5. | 1 |
  6. +---------------------+
  7. mysql> select from_base64('MjM0');
  8. +---------------------+
  9. | from_base64('MjM0') |
  10. +---------------------+
  11. | 234 |
  12. +---------------------+

keywords

  1. from_base64