THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL INSERT() Function

❮ MySQL Functions

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 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 the string2
number Required. The number of characters to replace
string2 Required. The string to insert into string

Return Values

  • If position is not 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

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 »

❮ MySQL Functions