MySQL Remove dots and commas from numbers in MySQL database

Wordpress MySQL 데이터베이스의 wp_postmeta 테이블 에는 meta_key = 'price'와 meta_value = 'XXX'가있는 대부분의 행이 있습니다. 여기서 XXX 숫자입니다. 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 귀하의 답변에 미리 감사드립니다!

 

해결 방법

 

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

 

참조 페이지 https://stackoverflow.com/questions/11210759