search

brix / crypto-js

JavaScript library of crypto standards.
Other
15.88k stars 2.39k forks source link

Decryption in mysql for encrypted string (using crypto-js) #391

Open bilalilyas90 opened 2 years ago

bilalilyas90 commented 2 years ago

Hi! I need some help to decrypt (in mysql) encrypted string (encrypted by crypto-js) and I can't find proper solution to decrypt in mysql.

in js I am using following code to encrypt and then save in mysql textEncrypted = AES.encrypt(text, secret).toString();

now I want to decrypt in mysql so I can use where conditions and order by and other clauses in my queries.

any help would be appreciated Thank you!

trasherdk commented 2 years ago

Maybe MySQL 12.14 Encryption and Compression Functions documentation has ideas.