Encrypt the field, lose the query.
Full-field encryption usually kills search, so teams encrypt the disk instead, leave the fields readable, and hope access controls hold. That protects against a stolen hard drive and nothing else.
- Disk encryption only: fields stay readable
- Application-side crypto breaks lookups and joins
- Search forces a plaintext column back into the schema
- Every workaround widens the blast radius