Hello I have a table with type and description, as below Type description Lot A Lot B Lot C Color Red Color Blue i need to retrieve, from database, a list of Type color. how do i do that? I need to write something like select * from table where type = ‘color’ Thank you