Fetch on multiple conditions

Fetch on multiple conditions

In the following statement, records with field named 'name' containing value of input.assigned_to will be fetched.

tm = team_member[name == input.assigned_to];

Is there a way to fetch records based on multiple conditions ? I know this can be done with a for-loop. But is a simpler and more efficient syntax?

Thanks for your prompt responses.
lakshmi