I would like to know the best way to set up a database so a query can easily search for a range of data. For example, my current mySQL database is as follows:



Using this table I would like to create a query for a plant that would be between 30-40 feet. This would display only the Bambusa oldhamii plant.

1) Is there a better way to set up the database for this? If so, how? Also, what would the query be?

2) Using the existing format, what would be the best way to query this for a range? Is it even possible?

Please let me know if you need clarification.

Thanks,

Rich

__________________
Me