[MySQL] INSERT()

MySQL 문자열 함수와 연산자

 

INSERT()

   -

 

INSERT(str, pos, len, newstr)

의 형태

 

Returns the string str, with the substring beginning at position pos and len characters long replaced by the string 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.

 

This function is multibyte safe.

 

mysql> SELECT INSERT('Quadratic', 3, 4, 'What') ;
+-----------------------------------+
| INSERT('Quadratic', 3, 4, 'What') |
+-----------------------------------+
| QuWhattic                         |
+-----------------------------------+
1 row in set (0.00 sec)

 

mysql> SELECT INSERT('Quadratic', -1, 4, 'What') ;
+------------------------------------+
| INSERT('Quadratic', -1, 4, 'What') |
+------------------------------------+
| Quadratic                          |
+------------------------------------+
1 row in set (0.00 sec)

 

mysql> SELECT INSERT('Quadratic', 3, 100, 'What') ;
+-------------------------------------+
| INSERT('Quadratic', 3, 100, 'What') |
+-------------------------------------+
| QuWhat                              |
+-------------------------------------+
1 row in set (0.00 sec)