Equivalent encryption logic in MySQL

user_4706874 0
Viewed 63

enter image description here

What will be equivalent encryption logic in MySQL ? Using something like following is not yielding require result.

select sha2('Tpostest123',256);

encryption mysql
1 Answers

SHA2 returns a hexidecimal string value; you want it in base64 form instead. For that, do:

select to_base64(unhex(sha2('Tpostest123',256)));
ysth_173890
Related