Feature request #7814

QgsExpression: LIKE operator should respect escaped _ and %

Added by Matthias Kuhn over 10 years ago. Updated about 5 years ago.

Pull Request or Patch supplied:No Resolution:fixed/implemented
Easy fix?:No Copied to github as #:16702


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.


LIKE "45!%" ESCAPE "!"
should match
"45%" but not "45% or more"


#1 Updated by Jürgen Fischer over 9 years ago

  • Tracker changed from Bug report to Feature request

#2 Updated by Giovanni Manghi over 6 years ago

  • Easy fix? set to No

#3 Updated by Jürgen Fischer about 6 years ago

  • Category set to Unknown

#4 Updated by Nyall Dawson about 5 years ago

  • Resolution set to fixed/implemented
  • Status changed from Open to Closed
  • Description updated (diff)

Fixed since ..?

Also available in: Atom PDF