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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users. For more options, visit https://groups.google.com/groups/opt_out.
