I am working on a new project that stores medical related information. We are working on a project that stored Healthcare related information. For Security reason we store users table fields value with encryption, to implement that we use trait that encrypts and decrypts on some selected fields of User Model and its working fine. Now I want to apply a filter on that encrypted data in Laravel query builder but the problem is that encrypted value seems to differ every time, even if given the same string.
So how can I apply a filter on database encrypted fields using Laravel query builder?