Submitted by: Sridhar MS(sridhar.ms@gmail.com)

Tuesday Jan 14th 2020 by Sridhar MS
Article Image

Language: SQL, Expertise: Intermediate: See how to repeat a particular string a defined number of times.

MySQL provides a REPEAT command that can be used when you want to repeat a particular string, a defined number of times.

Consider the example below:


Here, we can observe that the output is the text 'SEE'. The letter 'E' has been repeated two times as indicated in the argument.

| CONCAT('S',REPEAT("E",2))   |
| SEE                         | 
Mobile Site | Full Site