Collections:
FROM_BASE64() - Base64 Decoding
How to decode a Base64 string using the FROM_BASE64() function?
✍: FYIcenter.com
FROM_BASE64(str) is a MySQL built-in function that decodes a Base64 string. For example:
SELECT FROM_BASE64('RllJ'), TO_BASE64('FYI'); -- +---------------------+------------------+ -- | FROM_BASE64('RllJ') | TO_BASE64('FYI') | -- +---------------------+------------------+ -- | FYI | RllJ | -- +---------------------+------------------+ SELECT FROM_BASE64('My4xNA=='), TO_BASE64(3.14); -- +-------------------------+-----------------+ -- | FROM_BASE64('My4xNA==') | TO_BASE64(3.14) | -- +-------------------------+-----------------+ -- | 3.14 | My4xNA== | -- +-------------------------+-----------------+
Reference information of the FROM_BASE64() function:
FROM_BASE64(str): bin Takes a string encoded with the base-64 encoded rules used by TO_BASE64() and returns the decoded result as a binary string. Arguments, return value and availability: str: Required. The input Base64 string. bin: Return value. The decoded bytes. Available since MySQL 5.7.
Related MySQL functions:
⇒ HEX() - Calculate HEX representation
⇐ FIND_IN_SET() - Find Substring in List String
2023-11-18, 288🔥, 0💬
Popular Posts:
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...