MySQL data type and query

Hello again Kirupans!

I’m in the middle of designing a product database. I have a lot of products that are available in multiple flavors. However, rather than displaying EACH version of the products, I’d rather just list the series.

Allow this hypothetical example: **Cars

**I have multiple models of cars on my website. Each model comes with a subset of horsepower ratings. For instance, the Ford Mustang comes with a 210 and 300 horsepower rating. The Ford Fusion comes with 160 or 220 horsepower. The Ford Focus comes in 130, 136 or 150 horsepower.

What is the best datatype to use to store multiple values like that if these products need to be filtered by the user’s minimum and maximum horsepower?

If this needs any clarification, don’t hesitate to ask. I’ll make sure to respond as promptly as possible.

Thanks in advance everyone. These forums have been a great support.