this sql made me little complex situation
<p>Hi sql'ers though am dealing with SQL  from past 4 years. I encountered little complex situation today.</p>

<p>I have a mysql table with columns, id,movieid,Lang,comment, and timestamp so i want to render comment for a particular  movie in which user can decide a range that from where to where he wants a  comment for that particular movie but when i try the following query will not working out. So help me guys  I'm stucked.</p>

<pre><code>SELECT comment from aaa  where movieid=2 and language='en'  between6 to 10 
</code></pre>

<p>Here basically I need to fetch from 6th comment to 10th comment from my aaa table (only for passed movieid parameter). All help will be appreciated.</p>