CODE EXAMPLE FOR SQL

mysql pad zeros

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