Example
SELECT INSERT("ExampleSite.com", 1, 9, "Example");Definition and Usage
The INSERT() function inserts a string within a string at the specified position and for a certain number of characters.
Syntax
INSERT(
string
,
position
,
number
,
string2
)Parameter Values
| Parameter | Description |
|---|---|
| string | Required. The string that will be modified |
| position | Required. The position where to insert string2 |
| number | Required. The number of characters to replace |
| string2 | Required. The string to insert into string |
Return Values
- If position is outside the length of string , this function returns string
- If number is higher than the length of the rest of the string , this function replaces string from position until the end of string
Technical Details
| Works in: | From MySQL 4.0 |
|---|