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
27429	had to use QuerySet.extra to do WHERE LIKE with arbitrary amount / placement of wildcard characters	Lance Robertson	nobody	"My use case is that I'm trying to find phonetic patterns that rhyme using a database I built from the pronunciation dictionary CMUdict

For example: 
 {{{#!python
Pronunciation.objects.extra(where=[""code LIKE '%% - %%__1 - S T __0 D'""])
  }}}
I want to be able to filter with % and _ wildcards in arbitrary amounts and places in the search string beyond just contains, startswith, and endswith, and the only way I could figure out how to do it is either to use a raw query or .extra - if .extra goes away I hope filter will support this behavior!

"	Uncategorized	new	Uncategorized	1.10	Normal		QuerySet.extra		Unreviewed	0	0	0	0	0	0