MySQL8 REPEAT() Functions – String Functions

by · Published · Updated

REPEAT() Functions returns a string consisting of the input string repeated count times.

If count is less than(<) 1, it returns an empty string. Returns NULL if any argument is NULL.

Note : This function is similar to the PHP STR_REPEAT() function.

MySQL REPEAT() Functions: Syntax

REPEAT ( string, count );

MySQL REPEAT() Functions: Parameter

[table caption=”” width=”100%” colwidth=”15%|15%|15%|55%” colalign=”left|left|left|left”]
Name, Required /Optional,Type, Description
string, Required, String , It represents the valid input string.
count, Required, Numeric , It represents valid numeric value.
[/table]

MySQL REPEAT() Functions: Output

[table caption=”” width=”100%” colwidth=”20%|80%” colalign=”left|left”]
Return, Description
string, consisting of the input string repeated count times.
empty string, if count is less than(<) 1.
NULL, if any argument is NULL.[/table]

MySQL REPEAT() Functions: Available from

[table caption=”” width=”100%” colwidth=”25%|75%” colalign=”left|left”]
Version, MySQL 4.0
[/table]

REPEAT() Example 1 : Very easy example

We will be repeating the input string 2 times. Below is the example to show it.

mysql> SELECT REPEAT('mysql function tutorial!',2);
+--------------------------------------------------+
| REPEAT('mysql function tutorial!',2)             |
+--------------------------------------------------+
| mysql function tutorial!mysql function tutorial! |
+--------------------------------------------------+
1 row in set (0.00 sec)

REPEAT() Example 2 : not including space

Below is the example where we will be repeating the input  string 2 times.

mysql> SELECT REPEAT('mysql!',2);
+--------------------+
| REPEAT('mysql!',2) |
+--------------------+
| mysql!mysql!       |
+--------------------+
1 row in set (0.00 sec)

Some more examples :

mysql> SELECT REPEAT('mysql! ',3);
+-----------------------+
| REPEAT('mysql! ',3)   |
+-----------------------+
| mysql! mysql! mysql!  |
+-----------------------+
1 row in set (0.00 sec)

REPEAT() Example 3 : returns an empty string, if second parameter is less than 1

If count is less than 1, returns an empty string.

mysql> SELECT REPEAT('mysql! ',0);
+---------------------+
| REPEAT('mysql! ',0) |
+---------------------+
|                     |
+---------------------+
1 row in set (0.00 sec)

REPEAT() Example 4 : NULL arguments

If any of the arguments is NULL, it will return NULL. See below example

mysql> SELECT REPEAT('mysql tutorial!', NULL) as First, 
              REPEAT(NULL,5) as Second;
+-------+--------+
| First | Second |
+-------+--------+
| NULL  | NULL   |
+-------+--------+
1 row in set (0.00 sec)

See all MySQL String functions MySQL 8 String Functions.

Related articles : LOCATE(), HEX(), CONCAT(), CONCAT_WS() , LOWER(), LTRIM(), INSTR(), POSITION().

PHP Related articles : STR_REPEAT(), SUBSTR_COUNT(), SUBSTR_COMPARE(), SUBSTR_REPLACE(), STR_PAD(), PHP STRING FUNCTIONS().

You may also like...