title: MySql Need query that checks one condition and than checks for a second condition before returning result
body: <p>Suppose I have a table, Food_table with fields and rows: </p>
  
  <pre><code>food_type | food_name    | food_price
  Meat      | steak        | 7.00 
  Fruit     | red_apple    | 1.00
  Fruit     | green_apple  | 1.10
  Fruit     | yellow_apple | 0.50 
  ... etc
  </code></pre>
  
  <p>So how would I go about selecting say, All fruit that are apples and fall within price of a dollar + .10%, more or less ( $.90 >= food_price &lt;= $1.10 ). </p>
  
  <p>So this query would return red apple and green apple because they are fruits and are also apples AND their price is within $.90 and $1.10.</p>
  
  <p>In the given example, I know the price, However, what if I did not know the price of the fruit?</p>
  
  <p>My query:</p>
  
  <pre><code>$sql = "SELECT * FROM Food_table WHERE 
  food_type = 'Fruit' AND food_name LIKE '%apple%'  "
  </code></pre>
  
  <p>However, I'm missing the price clause.</p>
  
  <p>Thank you guys/gals</p>
  
  <p>Further explanation:
  If I have a 2 select box where a user selects the food_type, food_name and enters a price, how can I return that food with the price being 10% more or less?</p>