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: http://stackoverflow.com/questions/3037581/how-do-i-escape-from-python-mysql-query?rq=1 — kael, May 10 '13 at 22:45

score 1 · Accepted Answer · answered May 10 '13 at 22:21

1

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

answered May 10 '13 at 22:21

cmd

score 0 · Answer 2 · answered May 10 '13 at 22:22

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 '13 at 22:22

David542

2 Answers2