Functions used to intercept strings from Oracle and MySql

Oracle and MySql functions for string truncation Oracle: 1. truncates the string before a character (excluding the character) in the string select Substr (P. SCHEDULE_CODE, 1, Instr (P. SCHEDULE_CODE, '(', 1)-1) from M_SUB_TASK_SCHEDULE_LOG P; 2. truncates the string (including characters) before the character in the string select Substr (P. SCHEDULE_CODE, 1, Instr (P. SCHEDULE_CODE, '(ret', 1) from M_SUB_TASK_SCHEDULE_LOG P; www.2cto.com MySql: 1. intercept the first '(' All characters earlier (in good order) SELECT SUBSTRING_INDEX (P. SCHEDULE_CODE, '(', 1) FROM M_SUB_TASK_SCHEDULE_LOG P; 2. intercept the first '(' before all characters (reciprocal) SELECT SUBSTRING_INDEX (P. SCHEDULE_CODE, '(',-1) FROM M_SUB_TASK_SCHEDULE_LOG P;