[Qgis-user] ilike-operator

[Walter Nordmann]

try this:

https://stackoverflow.com/questions/4928054/postgresql-wildcard-like-for-any-of-a-list-of-words#4928415

|lower("Shape")similar to'(rectangle|triangle)' should do it. Regards 
walter btw: why are you using ilike without wildchars? |

Am 28.07.2017 um 12:30 schrieb "Torben Keßler":
> Hello,
> is there a more elegant way for saying the following:
> "Shape" ILIKE 'rectangle' OR "Shape" ILIKE 'triangle' ?
> [obviously "Shape" ILIKE ('rectangle' OR 'triangle') does not work]
> Many thanks!
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

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