Thread: How to remove comma in price field

How to remove comma in price field

Awhile back, i have been putting comma in the price field of the ad because in the old theme, it did not show the comma in the price.

How can I edit the existing price in the data base. Understand its written into cp_price fields but I can't find it in the core Wordpress table.

Can somebody teach me how to inject a SQL statement to remove the comma in the database instead of me removing them individually.

Thanks