how to trim leading zeros from alphanumeric text in mysql function

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”.

Answer

You are looking for the trim() function.

Alright, here is your example

SELECT TRIM(LEADING '0' FROM myfield) FROM table

Leave a Reply

Your email address will not be published. Required fields are marked *