title: mysql query in cakephp
body: <p>I would like to ask how can I can display only some data from a table to the user's view, using mysql query in cakephp. </p>
  
  <p>Example, I have a table Students. There are two fields, name and age.</p>
  
  <p>Clerk, 21 <br>
   Mary, 23 <br>
   Matt, 21 <br>
   Clara, 21<br></p>
  
  <p>Here is my query, <code>SELECT * FROM Students where age='21'</code>;</p>
  
  <p>How and where can I apply it in cakephp? Thanks.</p>