INSERT()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
Inserts a string in another string at the specified position.
EXAMPLES
SELECT INSERT('matheme', 3, 5, 'riadb');
+----------------------------------+
| INSERT('matheme', 3, 5, 'riadb') |
+----------------------------------+
| mariadb |
+----------------------------------+
SELECT INSERT('matheme', -1, 5, 'riadb');
+-----------------------------------+
| INSERT('matheme', -1, 5, 'riadb') |
+-----------------------------------+
| matheme |
+-----------------------------------+
SELECT INSERT('matheme', 3, 10, 'riadb');
+-----------------------------------+
| INSERT('matheme', 3, 10, 'riadb') |
+-----------------------------------+
| mariadb |
+-----------------------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.