Re: Selecting with a list of keys

2005-02-23 Thread Roger Baklund
Tim Johnson wrote: I would like to construct a query that searces on a variable list of primary keys. Example: Lkeys = [12, 23, 15, 17]## python - style list of integers Select column from table where ID in Lkeys; ## mysql statement? Is this possible, or does one have to generate a quer

Selecting with a list of keys

2005-02-23 Thread Tim Johnson
I would like to construct a query that searces on a variable list of primary keys. Example: Lkeys = [12, 23, 15, 17]## python - style list of integers Select column from table where ID in Lkeys; ## mysql statement? Is this possible, or does one have to generate a query for each key or