Get unique domains for an email field on a model

May 31, 2023 · 1 minute read

Django

from django.db.models import F, Value
from django.db.models.functions import StrIndex, Substr
from myapp.models import MyModel

MyModel.objects.annotate(
    at_pos=StrIndex('email', Value('@')) + 1, 
    domain=Substr('email', F('at_pos'))
).distinct('domain').values_list('domain', flat=True)