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
2559	[patch] Operators for search_fields	Andy Dustman <farcepest@…>	Adrian Holovaty	"Currently, search_fields in Admin always do an icontains search, i.e. ILIKE %...% search where ... is the search term. This is inefficient and undesirable in many cases because you cannot use an index and the database must search all rows.

The following patch (to be attached) extends this to add the following prefix operators and corresponding searches:

 * `^`: istartswith 
 * `=`: iexact
 * `@`: search (full-text)
 * no prefix: icontains (current behavior)

My tests indicate `^` makes my searches a lot faster. However, if there is at least one search field without a prefix, the database will still have to check every row."	enhancement	closed	contrib.admin	dev	normal	fixed		farcepest@…	Unreviewed	1	0	0	0	0	0