title: Fetch last ID where column is equal to a string
body: <p>I get confused on a sql statement and I kind of need your help.</p>
  
  <p>Below are my table entitled (tblfood) contents:</p>
  
  <pre><code>ID  Food_Name           Main_Ingredient  Drink
  1   Ham n Coke          Ham              Coke
  2   Cheese n Tea        Cheese           Ice Tea
  3   Ham n Coke          Ham              Coke
  4   Ham n Coke          Ham              Coke
  5   Chicken Sandwich    Chicken          None
  6   Chicken Sandwich    Chicken          None
  7   Cheese n Tea        Cheese           Ice Tea
  8   Chicken n Coke      Chicken          Coke
  9   Chicken Sandwich    Chicken          None
  10  Cheese n Tea        Cheese           Ice Tea
  </code></pre>
  
  <p>I want to get the <code>ID</code> of the last entered <code>Food_Name</code> with <code>Chicken Sandwich</code>, which is 10. And if I get the last entered <code>Food_Name</code> with <code>Chicken n Coke</code>, it would display 9.</p>
  
  <p>My first try goes like this:</p>
  
  <pre><code>Select id 
  from tblfood 
  where Food_Name='Chicken Sandwich';
  </code></pre>
  
  <p>But with this code, I believe it will display all the IDs where the Food_Name is equal to Chicken Sandwich.</p>
  
  <p>How should I display only the last entered ID?</p>