mysql zero pad string code example

Example: mysql pad zeros

SELECT LPAD(last4, 4, '0') as last4 FROM numbers;