Python Error - Not enough arguments for format string

Question

Hi I have the following query to Database. It is working correctly in SQL, but not working in python. How to solve this? Thanks in advance.

SELECT distinct id , id FROM XX WHERE id LIKE '01%' GROUP BY id

Martijn Pieters · Accepted Answer · 2015-09-02 10:02:10Z

1

Double the % to escape it, as Django treats it as a format string where % characters have special meaning:

SELECT distinct id, id FROM XX WHERE id LIKE '01%%' GROUP BY id
--                                              ^^

answered Sep 2, 2015 at 10:02

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

But am getting a strange error as invalid literal for int() with base 10: 'XX'

@blackwindow: How are you using the query in Django? Please add your actual code to your question. Give us the full traceback for the error too.