title: Python/MySQLdb/cursor.executemany()
body: <p>I am performing a very simple query to a given MySQL database. Let's say:</p>
  
  <pre><code>&gt;&gt;&gt; cur = mydb.cursor()
  &gt;&gt;&gt; results = cur.executemany("select field from table where field = %s", ('value1', 'value2', 'value3'))
  &gt;&gt;&gt; print results
  4
  </code></pre>
  
  <p>So far so good...</p>
  
  <pre><code>&gt;&gt;&gt; rows = cur.fetchall()
  &gt;&gt;&gt; print rows
  field for value3
  </code></pre>
  
  <p>So the problem is that it prints answer only for <code>value3</code> and not for <code>value2</code> and <code>value1</code></p>
  
  <p>How can I fetch the entire result for the operation I am doing.</p>
  
  <p>Thank you!</p>