MySQLDB - generating "...not in (1,2,3)" from Python list ?

Steve Zatz slzatz at hotmail.com
Mon Feb 23 13:20:27 EST 2004


Don't you just want:

cursor.execute("select * from T where C1 not in (%s,%s,%s)",params)

The DBAPI should be fine with params being a python list of integers
(as long as there are three of them).



More information about the Python-list mailing list