Make a query over encrypted field about django-encrypted-fields HOT 2 CLOSED

Unfortunately what you're asking for is impossible. The decryption is done in the application layer, and the query is running in the DB layer.

Django simply turns MyModel.objects.filter(names__startswith='mysearch') into a SQL query roughly like SELECT * from myapp_mymodel where names LIKE 'mysearch%';.

You either have to live without querying, or store the data unencrypted.

from django-encrypted-fields.

As @defrex has said, once data is encrypted what you're asking of the database is impossible. A work around is to load required fields into data structures at the application layer and then to run queries across those data structures. At that point "running queries" involves Python, not SQL or the Django ORM.

from django-encrypted-fields.