MySQL8 INSERT() Functions – String Functions

by · Published · Updated

MySQL INSERT() Functions: Syntax

INSERT ( string1, startpos, length, newstring );
 

MySQL INSERT() Functions: Description

INSERT() Functions push newstring at specified place up to specified number of characters  into existing string1. This will push a newstring at startpos upto given length into existing string1 to return replaced string.

Note : This function is multibyte safe.

MySQL INSERT() Functions: Parameter

[table caption=”” width=”100%” colwidth=”15%|15%|15%|55%” colalign=”left|left|left|left”]
Name, Required /Optional,Type, Description
string1, Required, String , It represents the valid input string.
startpos, Required, Numeric , It represents valid position to push newstring.
length, Required, Numeric , It represents the number of characters to be changed in string1.
newstring, Required, String , It represents valid newstring to be pushed.
[/table]

MySQL INSERT() Functions: Output

[table caption=”” width=”100%” colwidth=”20%|80%” colalign=”left|left”]
Return, Description
string1,  with the substring  beginning at position startpos and length characters long replaced by the string newstring.
string1, if startpos is not within the length of the string.
replaced string1,  Replaces the rest of the string from position startpos if length is not within the length of the rest of the string.
NULL, if any of the input is NULL. See example 3.
[/table]

MySQL INSERT() Functions: Available from

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

MySQL INSERT() Functions: Example 1

mysql> SELECT INSERT('tutorialphpmysql', 9, 5, 'mines');
+-------------------------------------------+
| INSERT('tutorialphpmysql', 9, 5, 'mines') |
+-------------------------------------------+
| tutorialminessql |
+-------------------------------------------+
1 row in set (0.00 sec)

MySQL INSERT() Functions: Example 2

mysql> SELECT INSERT('tutorialphpmysql', -1, 5, 'mines');
+--------------------------------------------+
| INSERT('tutorialphpmysql', -1, 5, 'mines') |
+--------------------------------------------+
| tutorialphpmysql |
+--------------------------------------------+
1 row in set (0.00 sec)

MySQL INSERT() Functions: Example 3

NULL is returned, if any of the input is NULL.

mysql> SELECT INSERT('tutorialphpmysql', null, 5, 'mines');
+----------------------------------------------+
| INSERT('tutorialphpmysql', null, 5, 'mines') |
+----------------------------------------------+
| NULL |
+----------------------------------------------+
1 row in set (0.00 sec)

MySQL INSERT() Functions: Example 4

mysql> SELECT INSERT('tutorialphpmysql', 9, 50, 'mines');
+--------------------------------------------+
| INSERT('tutorialphpmysql', 9, 50, 'mines') |
+--------------------------------------------+
| tutorialmines |
+--------------------------------------------+
1 row in set (0.00 sec)

See all MySQL String functions MySQL 8 String Functions.

Related articles : HEX(), CONCAT(), CONCAT_WS() , LOWER(), UPPER(), LTRIM(), RTRIM().

PHP Related articles : SUBSTR_REPLACE(), STR_REPLACE(), STR_IREPLACE(), PHP STRING FUNCTIONS().

You may also like...