To remove leading zeros in MySql

Avidnyat

To remove leading zeros from field following is the solution

select TRIM(Leading ‘0’ from FIELD) from Table

about the author

Avidnyat