<Can I search dB for list of items and return thei...

# stackoverflow

[user]

Can I search dB for list of items and return their IDs respectively?
I have a data table like "animals" and I want to search for 5 animals at once (open connection once) and get their IDs respectively then close the connection one time only - for the sake of performance - instead of opening connection everytime and search for one animal and then close the connection and redo this times.
Is there a way to do this