Feature request #7814
QgsExpression: LIKE operator should respect escaped _ and %
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Unknown | ||
| Pull Request or Patch supplied: | No | Resolution: | fixed/implemented |
| Easy fix?: | No | Copied to github as #: | 16702 |
Description
QgsExpression LIKE / ILIKE / NOT LIKE / NOT ILIKE operators do currently not allow to escape _ and % operators.
Default escape string should be a backslash \\ or customizable with an ESCAPE statement appended to the LIKE (et al) operator specifying an escape character.
E.g.
LIKE "45!%" ESCAPE "!"
should match
"45%" but not "45% or more"
History
#1
Updated by Jürgen Fischer over 10 years ago
- Tracker changed from Bug report to Feature request
#2
Updated by Giovanni Manghi over 7 years ago
- Easy fix? set to No
#3
Updated by Jürgen Fischer about 7 years ago
- Category set to Unknown
#4
Updated by Nyall Dawson about 6 years ago
- Resolution set to fixed/implemented
- Status changed from Open to Closed
- Description updated (diff)
Fixed since ..?