repeat string function of MySQL

We can repeat a string number of times by using repeat command. Here are some examples

SELECT REPEAT(' plus2net ', 3);

This will repeat our string plus2net three times. Like this

plus2net  plus2net  plus2net

What about this query ?

SELECT REPEAT(' plus2net ', 0);

No output or blank output

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com

▼ More on String

String Functions
substring_index to get part of a string from a delimiter
substring Part of string from a position
concat: adding a substring to all data present in a field
character_length: Number of chars in a string
locate: searching for a matching string inside field data
character_length: length of string present in a field for each record
ucase:lower to upper and upper to lower case conversion functions
left: left part of the string data in a field
replace: replace part of a sting with sub string in a field
length: string length function
reverse: string reverse function
repeat: string repeat number of times
RIGHT: Right part of the string
lpad: string padding from left
like: String pattern matching against record

Queries INSERT UPDATE

Aggregate Queries AVG ( Average ) SUM MIN MAX

SQL Video Tutorials

✖

We use cookies to improve your browsing experience. . Learn more

FORUM . Contact us

©2000-2022 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer