MySQL INSERT() Function
Example
Insert the string "Example" into the string "W3Schools.com". Replace the first nine characters:
SELECT INSERT("W3Schools.com", 1, 9, "Example");
Try it Yourself »
Definition and Usage
The INSERT() function inserts a substring into a string at a specified position for a certain number of characters.
Syntax
INSERT(string, position, number, substring)Parameter Values
| Parameter | Description |
|---|---|
| string | Required. The string that will be modified |
| position | Required. The position where to insert the substring |
| number | Required. The number of characters to replace |
| substring | Required. The substring to insert into string |
Note
- The first position in string is 1
- If position is not within the length of string, INSERT() will return string
- If number is not within the length of the rest of the string, INSERT() will replace string starting from position until the end of string
Technical Details
| Works in: | MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23 |
|---|
More Examples
Example
Insert the string "no" into the string "W3Schools.com". Replace three characters, starting from position 11:
SELECT INSERT("W3Schools.com", 11, 3, "no");
Try it Yourself »
