Searching encrypted data

Question

User2079058187 posted

I have sensitive data in a MySql database table which is encrypted using TripleDES. I would like to search that data and return a decrypted datatable. If the data was not encrypted this would be easy. But how do I search in an encrypted database?

Will I have to get the full database table decrypted in a datatable and seach that? If so how do I do that?

Answer 1

User665793701 posted

You can encrypt your serching key then execute the sql on the data base. It think it will solve your problem.

Regards,

Answer 2

User2079058187 posted

Good idea. Thanks. I shall try it.