SUBSTR_ORACLE()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
EXAMPLES
SELECT SUBSTR_ORACLE('mariadb',1);
+----------------------------+
| SUBSTR_ORACLE('mariadb',1) |
+----------------------------+
| mariadb |
+----------------------------+
SELECT SUBSTR_ORACLE('mariadb',2);
+----------------------------+
| SUBSTR_ORACLE('mariadb',2) |
+----------------------------+
| ariadb |
+----------------------------+
SET sql_mode=CONCAT(@@sql_mode, ',ORACLE');
SELECT SUBSTR('mariadb',-2);
+----------------------+
| SUBSTR('mariadb',-2) |
+----------------------+
| db |
+----------------------+