Parameter | Type |
---|---|
hex_string | string |
Returns: string
Example
query:
SELECT name, HEX_TO_BASE_64(SHA256(name))
FROM employees
ORDER BY name
LIMIT 1
results:
name | sha256 |
---|---|
Anna Snelling | 1MG85Xw9eX3WM4m7MWf/deW7vi/1pnwePvtVIHER1q0= |
A function used to convert a hex-encoded string to a base64-encoded string.
Parameter | Type |
---|---|
hex_string | string |
query:
SELECT name, HEX_TO_BASE_64(SHA256(name))
FROM employees
ORDER BY name
LIMIT 1
results:
name | sha256 |
---|---|
Anna Snelling | 1MG85Xw9eX3WM4m7MWf/deW7vi/1pnwePvtVIHER1q0= |