How to fire like and range query on PII encrypted column in mysql

129 Views Asked by At

I have different encrypted columns in my MySQL table for different PII data like email, date of birth, etc.I am using AES envelope encryption coupled with AWS KMS. The encryption and decryption is handled in the application. No MySQL inbuilt encryption functionalities are used. I am able to perform the full-text match of input email by encrypting it but unable to perform like query operation. Please suggest me solutions for performing different MySQL operations on encrypted PII data.

0

There are 0 best solutions below