What mysql functions are there (if any) to trim leading zeros from an alphanumeric text field?
Field with value “00345ABC” would need to return “345ABC”.
You are looking for the trim() function.
Alright, here is your example
SELECT TRIM(LEADING '0' FROM myfield) FROM table