I would not specify a product category in the same table as the product.
I would have another table for product categories with fields, id, product_id, category
This table might have 4 or 5 records with the same product id.
example
- Sports car
- Classic
- Chevrolet
- Corvette
All having the same id for the same car. So if someone searches for any of these categories this product is displayed.