| | |
LPAD mysql string functionWe can pad a string from left or from right by using LPAD or RPAD function respectively. We will use some examples to understand how these functions works. Here we will take plus2net as our input sting.
Example of LPAD
SELECT LPAD('plus2net',13,'**');
The output is here
*****plus2net
You can see we have plus2net of 8 characters long. To this we have added or Pad at left ( at starting ) so the resultant string is of total 13 chars length.
What if the required length is less than the original string?
SELECT LPAD('plus2net',2,'**');
The output is here
pl
This is first two chars of our input sting only.
| |
| |
|
|
|
|
|
