mysql 'LIKE' in Django python

Question

I am little new to Django,

My Question is How do i do %LIKE% of MYSQL in Django Filter

Want something like this

myModel.objects.filter(myField__**like**="xyz")

as we can do

myModel.objects.filter(myField__startswith="xyz")

for strings that starts with 'xyz' but i want to match anywhere in the myField content.

What i know it can be done by REGEX and .extra() but i want something very straight forward.

Thanks in advance.

this straight forward answer.if you look at the docs here docs.djangoproject.com/en/1.6/ref/models/querysets/… — sundar nataraj
– sundar nataraj, Commented Jul 14, 2014 at 7:41

eman.lodovice · Accepted Answer · 2014-07-14 07:42:27Z

4

You can do it like this:

myModel.objects.filter(myField__contains = "xyz")

Note: __contains is case sensitive. You can use __icontains if you don't care about the case of the text.

answered Jul 14, 2014 at 7:42

eman.lodovice

1921 silver badge6 bronze badges

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

Comments

bakkal · Accepted Answer · 2014-07-14 07:40:03Z

2

Use the contains operator my_model.objects.filter(my_field__contains='xyz') and icontains if you want case insensitivity

answered Jul 14, 2014 at 7:40

bakkal

55.6k12 gold badges136 silver badges113 bronze badges