INSERT(str,pos,len,newstr) : INSERT : String Functions MySQL TUTORIALS


MySQL TUTORIALS » String Functions » INSERT »

 

INSERT(str,pos,len,newstr)


Returns the original string if pos is not within the length of the string.

Replaces the rest of the string from position pos if len is not within the length of the rest of the string.

Returns NULL if any argument is NULL.

mysql>
mysql> SELECT INSERT('ABCDEFG', 34'ZZZ');
+--------------------------------+
INSERT('ABCDEFG', 34'ZZZ') |
+--------------------------------+
| ABZZZG                         |
+--------------------------------+
row in set (0.00 sec)

mysql>



Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

MySQL TUTORIALS

 Navioo String Functions
» INSERT