Indexing first n characters of Charfield in Django

user_13779320 0
Viewed 51

How to index a specific number of Characters on Django Charfield?

For example, this is how we index fields in Django, but I guess it applies to entire field or all characters.

class Meta:
       indexes = [
           models.Index(fields=['last_name', 'first_name',]),
           models.Index(fields=['-date_of_birth',]),
]

So, how to apply index to specific portion of field as shown in mysql below.

CREATE INDEX part_of_name ON customer (name(10));
django-models django python
1 Answers

You can create a functional index with the Substr function [Django-doc]:

from django.db.models.functions import Substr

# …

class Meta:
       indexes = [
           models.Index(fields=['last_name', 'first_name']),
           models.Index(fields=['-date_of_birth']),
           models.Index(Substr('pub_date', 0, 10), name='part_of_name')
       ]
user_675790
Related