Remove dots and commas from numbers in MySQL database

Question

In a Wordpress MySQL database, in wp_postmeta table, there are most rows with meta_key='price' and with meta_value='XXX' where XXX is a number. The meta_value is a long text field. The numbers stored in it have a different shape some are stored with a dot, meaning thousand (10.000 means ten thousand) others are stored with a comma, meaning hundredth (10,00 means ten). How to remove dots and comma so to have a pure number, without hundredth? In other words, 100.000 should be 100000 and 10,00 should be 10 Thank you in advance for your answers!

Answer 1

Try a global REPLACE function

UPDATE wp_postmeta
SET meta_value = REPLACE(REPLACE(meta_value,',00',''),'.','')
WHERE meta_key='price';