get distinct "title" in mysql in django

Question

I have used django to develop a web app. I want to get the distinct "title" form the queryset get by filter.

But I use mysql so could not pass "title" to distict. How could I filter the queryset with the distinct "title"?

query_set = CourseInfo.objects.filter(discipline_id=id).distinct('title')

return render(request, 'main.html',
                     context={'query_set':query_set})

I get error for this in mysql as it may only used in postgresql `

Mojtaba Arezoomand · Accepted Answer · 2021-06-16 04:18:00Z

0

It will give you distinct titles:

titles = CourseInfo.objects.filter(
    discipline_id=id
).order_by('title').values('title').distinct()

Note:
there is no such thing called SELECT DISTINCT ON in MySQL.
You can only use it in Postgresql but maybe GROUP BY helps you for converting SELECT DISTINCT ON query to MySQL query.
Check out this link then you kinda can convert this query to MySQL query.

answered Jun 16, 2021 at 4:18

Mojtaba Arezoomand

2,43513 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

get distinct "title" in mysql in django

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related