java - SELECT then UPDATE all rows from RESULTSET -

i wanting update rows in resultset select in 1 single update query.

here have come far:

select id_queue, status table status in (0,2) order status, id_queue asc update;  update table set status = 97 id_queue= " + id_combined + ";

so, guess need take id_queue ids, put them 1,2,3,4,5,6,7,8 id_combined.

any idea best way in java?

note: not trying update status 0 & 2 97, want use select resultset somewhere else.

not sure sql dialect using, worth try:

update table set status = 97 id_queue in (select id_queue table status in (0,2))

shell