How can we escape a percent character in a LIKE
expression in QGIS?
For example, if I have the following column:
123% , 15% , albert, greg, 15%
How do I select all the values with %
in it without changing the field?
It seems possible to do this in ArcGIS, according to this answer but I have not found an equivalent solution with QGIS.
I have tried escaping with %%
, \%
, \\\%
, [%]
, ^%
, etc. but without success.
[EDIT]
I actually truly was wondering if it is possible to escape the % (and _) character, rather than to use perfectly (valid) work-around. The example provided was but for illustration.
Any ideas?