Does anyone know how to setup this query using a PreparedStatement?
DELETE FROM table WHERE id IN (list of values)
Would it be significantly faster to do a query like this (where there could
be hundreds of values) versus running the DELETE separately for each value
(opening a new db connection each time)?
thx
andy