id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
17473	Add like and ilike lookups	Pablo Martín	nobody	"Add like and ilike [http://docs.djangoproject.com/en/dev/topics/db/queries/#field-lookups lookups].

Should be possible to do something like this:

{{{
    MyModel.objects.filter(field_name__like='xx%YY%zz')
    MyModel.objects.filter(field_name__ilike='xx%yy%zz')
    User.objects.filter(username__like='a%in')
}}}


Instead of:

{{{
    MyModel.objects.filter(field_name__regex='^xx.*YY.*zz$')
}}}


It is more quick and more readable.

I create the next [http://pypi.python.org/pypi/django-like app], after read the next [http://stackoverflow.com/questions/8644146/django-query-how-to-write-where-field-like-10-8-0 question]

I didn't understand why this is not coded"	New feature	closed	Database layer (models, ORM)	1.3	Normal	wontfix			Design decision needed	1	0	0	0	0	0