title: How to get records from column by limiting
body: <p>I'm trying to make query which gets records where numbers match from 10 to 20 from column category and order by views(from column views).</p>
  
  <p>I'm maked this :</p>
  
  <pre><code>  $sql = mysql_query("SELECT category,views FROM mytable order by rand() LIMIT 10 OFFSET 20 ");
  </code></pre>
  
  <p><strong>UPDATE:</strong>
  THIS WORKING PERFECT!!!</p>
  
  <pre><code>  $sql = mysql_query("SELECT category,views FROM mytable order by rand() BETWEEN 10 AND 20 ");
  </code></pre>