Simple SQL question - pulling value between min and max

Question

Okay, this is probably really simple but for some reason I'm totally fried on this and need some advice.

I have two columns in my database, budget_min and budget_max.

Oh the front end, I'm trying to build a search that will find everything between two budgets, say 1000 - 2000, or 2000 - 4000.

Need something like where budget_min > 1000 && budget_max < 2000 but that obviously is not the correct query.

Answer 1

Answered it with this question: http://stackoverflow.com/questions/2197250/sql-query-a-range-of-records-that-fall-within-a-min-and-max-value

Answer 2

Lots of direct options

where (X>22 AND X<55)

also

where X between 22 and 55