[MDEV-526] REGEXP ... ESCAPE Created: 2012-09-11 Updated: 2015-11-17 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Federico Razzoli | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
It has always been very hard to use regexp's with MySQL because... they need too many escape chars! The problem is that regexps use many '\', but that char needs to be doubles in the queries. Would it be possible to implement an ESCAPE clause, that works as in LIKE ... ESCAPE '|' ? |
| Comments |
| Comment by Pavel Cibulka [ 2014-11-28 ] |
|
I would rather see making NO_BACKSLASH_ESCAPES default. But that probably isn't going to happen soon. |
| Comment by Alexander Barkov [ 2014-11-28 ] |
|
I'd also prefer NO_BACKSLASH_ESCAPES by default, with a PostgreSQL syntax with 'E' for escaped strings: SELECT E'\r\n'; |
| Comment by Federico Razzoli [ 2014-11-28 ] |
|
i agree with the comments above |