I am using spring jpa with mysql database to encrypt the PII data by using the @convert annotation. The encryption and decryption is working properly. The problem is with search functionality. When i am searching with full text, search is working However when i try to search like below it is not working.
select email_id from customer where email_id like '%'+encryption(sher)+'%'.
can anyone suggest any help on this ? Or if there is any different approach for db column encryption/decryption which supports pattern search for encrypted data ?
Thank you!