DEV Community

Discussion on: I'm here to encourage you, ask me anything!

 
devmount profile image
Andreas

What encryption do you use?

Thread Thread
 
saikatharryc profile image
Saikat Chakrabortty

aes256 with output_encoding base64 & the secret & Iv key used for this, is again made with pbkdf2Sync with sha512 digest & keylength of 100000.

Thread Thread
 
devmount profile image
Andreas

Got it - well I don't see a way to do it directly in MySQL. You would have to walk through the whole table, decrypt each record and perform your regex search on it...