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