i want to delete a record having all encrypted fields including primary key. How can i delete that record if i have the primary key data in pain text.
problem is that every time encryption algorithm returning different text. so encrypting the plain text and comparing with the database isnt fetching the results.
i need to get all primary key fields from table decrypt it and then compare with plain text all these things will take much time when we are handling big tables.
did u come across any best practices regarding this area, if so let me or else give any good resources that i can access through net
Note that the encryption algoritm is applying at php engine not at the database server.

if its difficult suggest your methodology that encrypting all data in the table and decrypt them while presenting to ristricted people