What is the function of the insert?

MySQL INSERT() Function Previous MySQL Functions Next Example Insert the string "Example" into the string "W3Schools.com". Rep

What is the function of the insert?

MySQL INSERT() Function  Previous MySQL Functions Next

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


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 »
 Previous MySQL Functions Next  

Video liên quan