[Qgis-user] Select by Expression: exclusive (not inclusive)

[Alexandre Neto]

Hi Andrew,

Try using the NOT outside the IN operator

*NOT "tag_service" IN ('alley', 'drive-through', 'driveway', 'laneway',
'parking_aisle', 'parking')*

Alexandre Neto

User support
www.qcooperative.net


A quinta, 15/07/2021, 08:19, Andrew Hughes <ahhughes at gmail.com> escreveu:

> Thanks Marco,
>
> You've answered my question, so thank you. For reference, I've never see
> this in any sql rmdbs.
>
> Some examples my help the community, hopefully I will be able to
> contribute sooner or later.
>
> Thanks again!
> Andrew
>
>
> On Wed, 7 Jul 2021 at 17:43, GMAIL <casalbonim at gmail.com> wrote:
>
>> This is how sql works.
>> You want to apply a function to one column, and the column you are
>> comparing must have a value.
>> Consider this: tag_service != 'xxx' or null != 'xxx'. Null can't be
>> equal or unequal to any value. Even null = null or null != null returns
>> false
>>
>> hth
>> marco
>> _______________________________________________
>> 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
>>
> _______________________________________________
> 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/20210715/093960bd/attachment.html>