title: Extracting text fields from HTML using Python?
body: <p>what is the best way to extract data from this HTML file and put it into MySQL database with company phone number, company name and email with a primary key as phone number?</p>
  
  <pre><code>&lt;/tr&gt;&lt;tr class="tableRowOdd"&gt;
                  &lt;td&gt;"JSC company inc. 00" &amp;lt;email@email.com&amp;gt;&lt;/td&gt;
                  &lt;td&gt;1231231234&lt;/td&gt;
              &lt;/tr&gt;&lt;tr class="tableRowEven"&gt;
                  &lt;td&gt;"JSC company inc. 01" &amp;lt;email01@email.com&amp;gt;&lt;/td&gt;
                  &lt;td&gt;234234234234234&lt;/td&gt;
              &lt;/tr&gt;&lt;tr class="tableRowOdd"&gt;
                  &lt;td&gt;"JSC company inc. 02" &amp;lt;email2@email.com&amp;gt;&lt;/td&gt;
                  &lt;td&gt;32423234234&lt;/td&gt;
              &lt;/tr&gt;&lt;tr class="tableRowEven"&gt;
                  &lt;td&gt;"JSC company inc. 03" &amp;lt;email3@email.com&amp;gt;&lt;/td&gt;
                  &lt;td&gt;23423424324&lt;/td&gt;
              &lt;/tr&gt;&lt;tr class="tableRowOdd"&gt;
                  &lt;td&gt;"JSC company inc. 04" &amp;lt;email4@email.com&amp;gt;&lt;/td&gt;
                  &lt;td&gt;234234232324244&lt;/td&gt;
              &lt;/tr&gt;   &lt;tr&gt;
  </code></pre>