it's expensive and you need to do
WHERE toLower(e1.word) IN [w in e2.WordsList | toLower(w)]
or
WHERE ANY(w IN e2.WordsList WHERE toLower(e1.word) toLower(w))
you can also store lower case words in your properties, or add a 2nd
property to check for that.
I am having issues caused by case sensitive matches ,
can someone please help ?
here is my query:
> MATCH (e1:Entity), (e2:Entity) WHERE e1.Word in e2.WordsList and e1.Word
> ={name}
>
Word is a string
WordsList is List<string>
how can I ignore the case when checking if a word is inside a list ?
Join our new Community Site & Forum <https://community.neo4j.com>
On Tue, Feb 12, 2019 at 11:46 AM <[email protected]> wrote:
>
> Hi,
>
> I am having issues caused by case sensitive matches ,
> can someone please help ?
>
> here is my query:
>
>
>> MATCH (e1:Entity), (e2:Entity) WHERE e1.Word in e2.WordsList and e1.Word
>> ={name}
>>
>
> Word is a string
> WordsList is List<string>
>
> how can I ignore the case when checking if a word is inside a list ?
>
>
> Thanks
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
