Trouble escaping mysql statement in python

Question

How would I escape the % in the following:

cursor.execute('''SELECT MIN(id) FROM title WHERE provider=%s 
                  AND vendor_id LIKE "%s%"''', (provider, vendor_id_stem))

You might look at this version of your question: stackoverflow.com/questions/3037581/… — kael
– kael, Commented May 10, 2013 at 22:45

cmd · Accepted Answer · 2013-05-10 22:21:58Z

1

cursor.execute("SELECT MIN(id) FROM title WHERE provider=%s"
               "AND vendor_id LIKE '%s%%'", (provider, vendor_id_stem))

answered May 10, 2013 at 22:21

cmd

5,88819 silver badges31 bronze badges

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

Comments

David542 · Accepted Answer · 2013-05-10 22:22:00Z

0

Add it as a python variable:

cursor.execute("SELECT MIN(id) FROM title WHERE provider=%s AND 
                vendor_id LIKE %s", (provider, vendor_id_stem + '%'))

answered May 10, 2013 at 22:22

David542

112k211 gold badges583 silver badges1.1k bronze badges