Decryption and using the Like SQL Statement

Question

I am relatively new to SQL and PostgreSQL and was wondering, if there is a way to use the like key word and pgp_sym_decrypt without decrypting the entire column to use the like statement (i.e)

SELECT pgp_sym_decrypt("Column_Name", 'Password_Number') FROM Table_Name 
WHERE pgp_sym_decrypt("Column_Name", 'Password_Number') LIKE '%a%';

Thanks for the help.

wilsotc · Accepted Answer · 2014-05-28 18:50:43Z

1

No, and this will cause a linear search of the entire table when it's used. The decrypted value to be evaluated for like will have to be done for every record in the table.

answered May 28, 2014 at 18:50

wilsotc

8105 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Decryption and using the Like SQL Statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related