How to remove commas of integer from MY SQL select query

Question

I am using a mySQL statement that returns me average of values as comma separated integer.

Eg : 2,109. But I want my output to be plain integer like 2109. Please help me on this.

Answer 1

You can use something like this:

SELECT REPLACE(fieldname, ',', '')
FROM ...

Or if type of fieldname is integer use this query

SELECT REPLACE(CONCAT(fieldname), ',', '')
FROM ...