Python MySQLdb string substitution without added quotations

I'd like to use string substitution for a comma-separated list, such as:

query = """SELECT id, name, image_id
           FROM users
           WHERE id IN (%s)
           """
values = (','.join(uids))
results = dbc.getAll(query, values

This ex开发者_开发问答ecutes the query:

SELECT id, name, image_id
FROM users
WHERE id IN ('1,2,3')

Which does not work as expected.

How can I do a substution so that I get the query without the quotations, such as:

SELECT id, name, image_id
FROM users
WHERE id IN (1,2,3)

---

Let MySQLdb do the entire argument substitution. In this case, the expected argument, values, should be the sequence (1,2,3), rather than the string '1,2,3':

query = """SELECT id, name, image_id
           FROM users
           WHERE id IN %s
           """    
values = uids
results = dbc.getAll(query, [values])

---

For me it worked this way:

cursor.execute(sql, (pids_list,))

and I made sure that elements of the pids_list are integers and not strings.