[Qgis-user] ilike-operator

[Walter Nordmann]

please try it. it does work! qgis filter is usually accepting all valid 
sql queries.

filter: lower("value") similar to '(berlin|london|paris)'

https://wambachers-osm.website/images/osm/snaps_2017/similar.png

ok, havin problems with hstore, but that's is another question.

regards
walter

Am 28.07.2017 um 13:31 schrieb "Torben Keßler":
> Thanks! Just erased the wildchars to shorten the code.
> I forgot to mention that I'm trying this as a QGIS (v 2.18.7) filter, 
> not in ProstgreSQL. There, I have only "ilike" as suitable string 
> operator, it seems.
> Best,
> Torben
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170728/e3a1b857/attachment.html>