title: MySQL MyISAM how to perform a read without locking a table?
body: <p>My question is a follow up to <a href="https://stackoverflow.com/a/918092/37759">this answer.</a>  I want to find out how to perform a select statement without locking a table with MyISAM engine. </p>
  
  <p>The answer states the following if you have InnoDB but not MyISAM.  What is the equivalent for MyISAM engine? </p>
  
  <pre><code>SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;
  SELECT * FROM TABLE_NAME ;
  COMMIT ;
  </code></pre>