MySQL REPEAT() Function

Repeat a string 3 times:

SELECT REPEAT("SQL Tutorial", 3);

Definition and Usage

The REPEAT() function repeats a string as many times as specified.

REPEAT( string, number)

Parameter	Description
string	Required. The string to repeat
number	Required. The number of times to repeat the string

Works in:	From MySQL 4.0

Repeat the text in CustomerName 2 times:

SELECT REPEAT(CustomerName, 2)
FROM Customers;

Repeat the string 0 times:

SELECT REPEAT("SQL Tutorial", 0);