title: MYSQL Select row_number() doesn't work
body: <p>I'm trying to get row 5 to 10 when sorting by date but for some reason I always end up with this sql error: </p>
  
  <blockquote>
    <p>1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
    near '(ORDER BY CreatedDate) AS Row, GameID, UserID, Title,
    Description, CreatedDate F' at line 1</p>
  </blockquote>
  
  <p>This is the query I'm trying to use:</p>
  
  <pre><code>SELECT ROW_NUMBER() OVER (ORDER BY CreatedDate) AS Row, GameID, UserID, Title, Description, CreatedDate
  FROM game
  WHERE Row &gt;= 5 AND Row &lt;= 10
  </code></pre>
  
  <p>Does someone know what I'm exactly doing wrong here? Or even a better way to solve this problem?</p>
  
  <p>Thanks for reading/helping</p>