In django, how can I filter or exclude multiple things?

Question

If I have this queryset:

player = basketball.objects.all()

How can I do a filter where I ask for multiple people? For example: I only want players who's names are "mike" or "charles" to show up. This doesn't seem to work for me:

player.filter(name = 'mike' , 'charles')

Does anyone know the best way to go about this?

Answer 1

You can use __in:

player.filter(name__in=['mike', 'charles'])

Answer 2

Alongside the use of __in, you can also chain multiple filters using the Q object, so objects.filter(q) where q = Q(Q(name="mike")|Q(name="phil")).

Definitely use __in though in this case.