Selection query

I need to select records from sql based on values in the table that has fields with multiple values

for example if there is a column named Material that has Silk,jute,cotton,etc., as data

and in the front end I have a combo box that has those materials name and "ALL" as additional if all is selected i need to show all the materials else if particular material is selected then that has to be shown. Similarly i have to filter based on many fields o is there any query to do so