Try using 2 %'s in your query
like this:
CLASSNAME.objects.raw("select * from table where full_name like
'%%ipod%%nano%%' ")
On Jun 6, 6:17 pm, Gyanit Singh <[email protected]> wrote:
> Hi All,
>
> As start I know there is __contains [http://docs.djangoproject.com/en/
> dev/ref/models/querysets/#contains]. But it only does LIKE '%word%'
> query.
>
> I want to do LIKE '%word1%word2%' query.
>
> for e.g. select * from table where column LIKE '%ipod%nano%'.
>
> The raw sql query is trying to replace percentage and throwing error
> that there are no parameters.
>
> both CLASSNAME.objects.raw("select * from table where full_name like
> '%ipod%nano%' ")
> CLASSNAME.objects.raw("select * from table where full_name like '\%ipod
> \%nano\%' ")
> throws
> Traceback (most recent call last):
> File "<console>", line 1, in <module>
> File "C:\Python26\lib\site-packages\django\db\models\query.py", line
> 1376, in __repr__
> return "<RawQuerySet: %r>" % (self.raw_query % self.params)
> TypeError: not enough arguments for format string
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
