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, 1863🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...