Querying full name in Django

by

This question was posted long time ago, but I had the similar problem and find answers here pretty bad. The accepted answer only allows you to find exact match by first_name and last_name. The second answer is a little bit better but still bad because you hit database as much as there was words.
Here’s my solution that concatenates first_name and last_name annotates it and search in this field:

from django.db.models import Value as V
from django.db.models.functions import Concat   

users = User.objects.annotate(full_name=Concat('first_name', V(' '), 'last_name')).\
                filter(full_name__icontains=query)

For example if the name of the person is John Smith, you can find him by typing john smith, john, smith, hn smi and so on. It hits database only ones. And I think this will be the exact SQL that you wanted in the open post.

More Related Contents:

  1. What is related_name used for?
  2. How to debug in Django, the good way? [closed]
  3. Django DB Settings ‘Improperly Configured’ Error
  4. Setting Django up to use MySQL
  5. How to create an object for a Django model with a many to many field?
  6. Count frequency of values in pandas DataFrame column
  7. Using only the DB part of Django
  8. django abstract models versus regular inheritance
  9. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  10. Django serializer Imagefield to get full URL
  11. How to set the timezone in Django
  12. Python + Django page redirect
  13. Use only some parts of Django?
  14. Python and character normalization
  15. Pass extra arguments to Serializer Class in Django Rest Framework
  16. ‘WSGIRequest’ object has no attribute ‘user’ Django admin
  17. Django: AppRegistryNotReady()
  18. django import error – No module named core.management
  19. Meaning of leading underscore in list of tuples used to define choice fields?
  20. -bash: ./manage.py: Permission denied
  21. Easiest way to rename a model using Django/South?
  22. How to run django unit-tests on production database?
  23. CSRF verification failed. Request aborted
  24. How to use jinja2 as a templating engine in Django 1.8
  25. Do CSRF attacks apply to API’s?
  26. Good ways to sort a queryset? – Django
  27. Resize fields in Django Admin
  28. Rendering JSON objects using a Django template after an Ajax call
  29. Django — Conditional Login Redirect
  30. How to properly use the “choices” field option in Django

Leave a Comment