MySQL FROM_BASE64()

MySQL 문자열 함수와 연산자

 

FROM_BASE64()

   -

 

FROM_BASE64(str)

의 형태

 

Takes a string encoded with the base-64 encoded rules used by TO_BASE64() and returns the decoded result as a binary string. The result is NULL if the argument is NULL or not a valid base-64 string. 

 

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)