title: How to make limit offset dynamic using only (My)SQL
body: <p>This code doesn't work</p>
  
  <pre><code>select pagenr into @offset from pages where id = 3;
  select * from table1 limit @offset*10, 10;
  </code></pre>
  
  <p>What SQLcode do I need to use in order to get this kind of code to work<br>
  using <strong>only</strong> SQL!</p>
  
  <p>Note that  </p>
  
  <pre><code>SET SQL_SELECT_LIMIT = @count 
  </code></pre>
  
  <p>doesn't work because I'm mainly concerned with the offset, not the limit as such.</p>