Recently I come across this request: the columns values must be encrypted, even programmers (means the programmers for this project) also cannot access the database.
What I can think of is to encrypt all the columns data, which I found the solution here. But then another issue comes, if I want to perform search, and columns are encrypted, which mean I cannot use WHERE
to filter the result, instead, I have to retrieve all the records from the table, then only filter by PHP script. I just couldn't imagine if there are 10mil records...
Anyone of you facing this kind of problem? Can suggest any solutions here.
Thanks