title: How to prevent table lock with MYSQL select with Innodb
body: <p>I have an issue with a select statement that locks a table.
  I have tried the "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;" thing, played with autocommit on off, etc., but it always locks the table.
  They say Innodb uses row level locking, but I think the table gets scanned and it causes the whole table to be locked.</p>
  
  <p>Query:</p>
  
  <pre><code>select  ID, RefNr 
  from TRMSMain.tblcalldata  
  where  (CallStarted BETWEEN '2014/06/13' AND '2014/06/13 23:59:59') 
  ORDER BY ID DESC LIMIT 0 , 50
  </code></pre>
  
  <p>This shows me there is a lock on the table:</p>
  
  <pre><code>show open tables where in_use &lt;&gt; 0;
  </code></pre>
  
  <p>Is there any other way to prevent the select from locking the table?
  I have googled and tried many things already.
  Many thanks
  Anton</p>