Finding value in ranges

[Ben D]

Hi All,

I have a table named distribution_details with the following structure and am including just a small subset of rows to try and help explain my issue.

| id |	| max_days |	| pct_to_management_company |
-----------------------------------------------------
  10	  3	          95.00
  1	  10	          90.00
  4	  30	          80.00
  6       45              75.00

I need to get the value that is in pct_to_management_company column based on a value(calculated using TIMESTAMPDIFF() that returns the number of days) that falls within the max_days column

So if I get a value of 4 returned by TIMESTAMPDIFF() I would need to find the row where 4 would be in a specific range. In this instance where max_days > 3 AND max_days <= 10

There could be an infinite number of rows here and I'm just not sure how I can get a bunch of different ranges to see where this number would fall into. Would this even be possible with just a query?

Thanks,
Ben