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
7130	MySQL 4.1 and the NOT LIKE in QuerySet refactor Fails	bo <bo.blanton@…>	George Vilches	"A simple Query to find things not like

{{{
Myobject.objects.all().exclude(name__icontains = ""moo"")
}}}

results in the Query

{{{
SELECT * from myobject where NOT name LIKE ""%moo%""
}}}

which works for MySQL 5.X, but not for 4.X, it was (before the refactor)

{{{
SELECT * from myobject where NOT (name LIKE ""%moo%"")
}}}

which works in both 5.X and 4.X

weather or not you 'support' at least MySQL 4.1 is unknown to me really, but if you do, then this is a little thing that needs fixing


"		closed	Uncategorized	dev		fixed	qsrf-cleanup		Unreviewed	0	0	0	0	0	0