Django – how do I select a particular column from a model?

Use values() or values_list().

If you use values(), You’ll end up with a list of dictionaries (technically a ValuesQuerySet)

instance = MyModel.objects.values('description')[0]
description = instance['description']

If you use values_list(), you’ll end up with a list of tuples

instance = MyModel.objects.values_list('description')[0]
description = instance[0]

Or if you’re just getting one value like in this case, you can use the flat=True kwarg with values_list to get a simple list of values

description = MyModel.objects.values_list('description', flat=True)[0]

See the official documentation

Leave a Comment