I have a table on my site that are home builders. They build homes between a specific range, say $100,000 to $700,000. I'm trying to make that searchable to a user who is looking for a builder who builds within there own submitted range, say $200,000 to $250,000. Any suggestions to do this? I know I can use BETWEEN to search if an integer is between a range, but how would I search for a range within a range?

Ex:

```
SELECT post_id FROM wp_posts WHERE meta_price_range BETWEEN 200000 AND 300000

```