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 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 »

❮ MySQL Functions