RPAD mysql string function
MySQL RPAD string function is used to pad strings from right. We will use this function along with select query but it can be used along with any other string commands.
Here are some examples of RPAD function
The output is here plus2net*******
We have added another string to right of our input string and the final output is of length 15 char. One more example is here
SELECT rpad( 'plus2net', 15, 'abc' )
Output of this is plus2netabcabca
What happens if we give less than the input string length.
SELECT rpad( 'plus2net', 5, 'abc' )
Output will be plus2 ( Upto 5 char only )
Be the first to post comment on this article :