Issue Resolved.. Thanks a lot For you Inputs. INSERT INTO dialplan(id, dpid, pr, match_op, match_exp, match_len, subst_exp, repl_exp, attrs) VALUES (2, "1", "2", 1, "^000[0-9]+\\$ ", 0, "^000([0-9]+)$", "", " ");
Thanks & Kind Regards, Logeshwaran G On Thu, Aug 10, 2017 at 10:13 AM, Logeshwaran G <logeshwara...@gmail.com> wrote: > Hi, > I have changed the rules as you mentioned > > INSERT INTO dialplan(id, dpid, pr, match_op, match_exp, match_len, > subst_exp, repl_exp, attrs) VALUES (1, "1", "1", 1, "^000[0-9]+$ ", 0, > "^000([0-9]+)$", "\\1", " "); > > Eventhough its failing. > > Thanks & Kind Regards, > Logeshwaran G > > On Wed, Aug 9, 2017 at 5:05 PM, Daniel Tryba <d.tr...@pocos.nl> wrote: > >> On Wed, Aug 09, 2017 at 01:34:13PM +0530, Logeshwaran G wrote: >> > I have given the below query, >> > >> > INSERT INTO dialplan(id, dpid, pr, match_op, match_exp, match_len, >> > subst_exp, repl_exp, attrs) VALUES (1, "1", "1", 1, "^000[0-9]+$ ", 0, >> > "^000([0-9]+)$", "\1", " "); >> > >> > But the Rule is tking as "1" >> >> See >> https://dev.mysql.com/doc/refman/5.7/en/string-literals.html >> "Within a string, certain sequences have special meaning unless the >> NO_BACKSLASH_ESCAPES SQL mode is enabled. Each of these sequences begins >> with a backslash (\), known as the escape character. MySQL recognizes >> the escape sequences shown in Table 9.1, “Special Character Escape >> Sequences”. For all other escape sequences, backslash is ignored. That >> is, the escaped character is interpreted as if it was not escaped. For >> example, \x is just x. These sequences are case sensitive. For example, >> \b is interpreted as a backspace, but \B is interpreted as B. " >> >> _______________________________________________ >> Kamailio (SER) - Users Mailing List >> sr-users@lists.kamailio.org >> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >> > >
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users