how to pad zero in mysql code example Example: mysql pad zeros SELECT LPAD(last4, 4, '0') as last4 FROM numbers;