How to get rows from database by many ids

If you have an array of ids of one table and you have to get a column say ‘id’ from the tableabc by these ids.

So it’s possible to get them with one query without making many many queries to DB or making a super long query.

You probably need to do something like:

SELECT b.*
FROM bids b
WHERE id IN (SELECT bid_id FROM table1);

SELECT b.*

FROM bids b

WHERE id IN (SELECT bid_id FROM table1);