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

Your Rating

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

SQL Popular Tutorials

Order by displaying records Records Between two date ranges Some of the records by LIMIT query SQL SUM of data in columns

✖

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

FORUM . Contact us

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