THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL REPEAT() Function

❮ MySQL Functions

Example

Repeat a string 3 times:

SELECT REPEAT("SQL Tutorial", 3);
Try it Yourself »

Definition and Usage

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

Syntax

REPEAT(string, number)

Parameter Values

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

Technical Details

Works in: From MySQL 4.0

More Examples

Example

Repeat the text in CustomerName 2 times:

SELECT REPEAT(CustomerName, 2)
FROM Customers;
Try it Yourself »

Example

Repeat the string 0 times:

SELECT REPEAT("SQL Tutorial", 0);
Try it Yourself »

❮ MySQL Functions