mysql range between query example get price between range value

i think any one can help by this query range between query example 

SELECT *
FROM `wp_lalyl_wp_discount_price`
WHERE `p_id` =14
AND 3
BETWEEN `min_qty`
AND `max_qty`