Re: 'LIKE' statement in Model.objects.raw() with percentage '%'

I tried to make it simple like this:

placeTag = "'\%"+placeTag+"\%'"

...

query = r""" ... WHERE placeType_id = %s AND placeTag LIKE %s ... """

The query string is correct:

WHERE placeType_id = 1 AND placeTag like '\%tes\%'

But i got no result in django. When i execute it in mysql client i got results. I've tried this forms too:

- placeTag = "%"+placeTag+"%'" => WHERE placeType_id = 1 AND placeTag like '%tes%'

- placeTag = "%%"+placeTag+"%%'" => WHERE placeType_id = 1 AND placeTag like '%%tes%%'

But still no results. Any idea about the results?

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
For more options, visit https://groups.google.com/groups/opt_out.