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:
SELECT CONCAT('S',REPEAT("E",2))
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 | +-----------------------------+