Searching encrypted data RRS feed

  • 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?

    Wednesday, January 25, 2012 11:39 AM

All replies

  • User665793701 posted

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


    Wednesday, February 29, 2012 4:40 AM
  • User2079058187 posted

    Good idea. Thanks. I shall try it.

    Wednesday, February 29, 2012 7:19 AM