解决TypeError: not enough arguments for format string

>>> all_ins = Ins.objects.raw("select p from ins where p like '11.%' and stat = 1")
>>> 
>>> all_ins[0]
Traceback (most recent call last):
  File "<console>", line 1, in <module>
  File "/usr/local/lib/python2.7/site-packages/Django-1.8.7-py2.7.egg/django/db/models/query.py", line 1323, in __getitem__
    return list(self)[k]
  File "/usr/local/lib/python2.7/site-packages/Django-1.8.7-py2.7.egg/django/db/models/query.py", line 1284, in __iter__
    query = iter(self.query)
  File "/usr/local/lib/python2.7/site-packages/Django-1.8.7-py2.7.egg/django/db/models/sql/query.py", line 80, in __iter__
    self._execute_query()
  File "/usr/local/lib/python2.7/site-packages/Django-1.8.7-py2.7.egg/django/db/models/sql/query.py", line 98, in _execute_query
    self.cursor.execute(self.sql, self.params)
  File "/usr/local/lib/python2.7/site-packages/Django-1.8.7-py2.7.egg/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python2.7/site-packages/Django-1.8.7-py2.7.egg/django/db/backends/mysql/base.py", line 124, in execute
    return self.cursor.execute(query, args)
  File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 159, in execute
    query = query % db.literal(args)
TypeError: not enough arguments for format string

问题的原因在于sql里的百分号，需要成对出现，这样就可以了。

>>> all_ins = Ins.objects.raw("select p from ins where p like '%11.%' and stat = 1")

其实要实现’11.%’ 的模糊查询，django是支持的：p__startswith='11.'