Get result where variable is in between

[micmac]

Hi all,
Please view attachement for reference.
If i have a post code variable like so:

$post_code = "2745";

how do i select the sub_kg column (see image) where $post_code is between post_code_min and post_code_max?
So the result should be 0.37

Cheers.

[leatherback]

"select * from TABLE where post_code_min < $post_code and post_code_max > $post_code";