title: MySQL SUM longtext field with $1.000.00 as 1000
body: <p>I have a column <code>meta_entry</code> of type <code>longtext</code> with two entries in it <code>$1.000.00</code> and <code>$54.00</code><br>
  When I run <code>SUM(SUBSTRING(meta_value, 2))</code> I get <code>55</code> because it doesn't read the first entry as <code>1000</code> rather it reads it as <code>1</code> because of the <code>.</code> after the <code>1</code><br>
  How can i write a query that will ignore the periods, while still keeping the period at the end of the number (before the cents)?</p>