How Can I Search Database Rows Already Read By Different Column Combinations?

I have a database table called lookups. It has fields such as:

description
lookup_type
is_deleted
is_hidden
is_a_demo

I would like to be able to do one database read of all my lookups, and then find various combinations from the locally stored array of values on the client side.

How would I index into the read values to find the sub-array with different combinations of these fields? So for example, having all lookup values stored in lookups.data.lookups, and to then find all those with

lookup_type=14
is_hidden=0 and 
is_a_demo=0

Best wishes,

Antony.

Community Page
Last updated: