plus2net Home
HOME
PHP
JavaScript
HTML
Python
ASP
jQuery
C
PhotoShop
SQL
SQL Home
Database Basic
PHP MySQL
Date
Math
Select
Insert
Delete
Left Join
String
Search
String Functions
String functions
substring_index :part of string from a delimiter
substring Part of string from a position
concat: adding a substring to data of a field
convert: Converting data type
FIND_IN_SET: searching within a set of strings
locate: searching for a string inside field
character_length: length of string
ucase:lower to upper and upper to lower case
left: left part of the string data in a field
replace: replace part of a sting with sub string
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
Login
×
Login
Username
Password
Login
Contact Us
repeat() : repeat string a string number of times
SQL
querying data
SELECT
WHERE
STRING
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
←
SQL String References
elt(): String from the postion
→
substring_index to get part of string using delimiter
→
←
Subscribe to our YouTube Channel here
This article is written by
plus2net.com
team.
https://www.plus2net.com
Subscribe
*
indicates required
Email Address
*
First Name
Last Name
Subscribe to plus2net
plus2net.com
Share your comments, suggestions, issues, or requests here.
Detail
Queries
INSERT
UPDATE
Aggregate Queries
AVG ( Average )
SUM
MIN
MAX
SQL Video Tutorials
SQL Exercise
✖
We use cookies to improve your browsing experience. .
Learn more
HTML
MySQL
PHP
JavaScript
ASP
Photoshop
Articles
FORUM
.
Contact us
©
2000-2024
plus2net.com
All rights reserved worldwide
Privacy Policy
Disclaimer