I have a table with four colums. the first column is the name of the category that the product are in. (this is a webshop). What I want is to output only the products that are in the one category. If this is the database:
shoes : brown shoes : 100 dollars : great shoes
sunglasses : brown shoes : 100 dollars : great shoes
shoes : brown shoes : 100 dollars : great shoes
sunglasses : brown shoes : 100 dollars : great shoes
Then I only want to list the products that have shoes as category. I could need some info about which mysql function to use. Are kind of new when it comes to using mysql