laziness, impatience, and hubris | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
mysql supports the IN() clause. So it might be easiest to use this: SELECT id, size FROM table WHERE id IN ('$id[0]', '$id[1]', ...)Which i would build this way, but there are plenty of others:
Apparently there are issues with the length of @id: past a certain point it would need to be divided into chunks for this approach to work. update *sigh*. redundant again. In reply to Re: how do i construct a sql select statement, where i want to get the where clauses out of an array
by thpfft
|
|