REPEAT() - Repeating String
Q
How to repeat a string multiple times using the REPEAT() function?
✍: FYIcenter.com
A
REPEAT(str, count) is a MySQL built-in function that
repeats a string for a given number of times.
For example:
SELECT REPEAT('Echo, ', 3);
-- +---------------------+
-- | REPEAT('Echo, ', 3) |
-- +---------------------+
-- | Echo, Echo, Echo, |
-- +---------------------+
Reference information of the REPEAT() function:
REPEAT(str, count): modstr Returns a string consisting of the string str repeated count times. If count is less than 1, returns an empty string. Returns NULL if str or count are NULL. Arguments, return value and availability: str: Required. The given string to be repeated. modstr: Return value. The repeated string. Available since MySQL 4.0.
⇒ REPLACE() - Replacing Substring
⇐ QUOTE() - MySQL Quoting String
2023-11-13, 227🔥, 0💬
Related Topics:
