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 <devher...@gmail.com> 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 neo4j+unsubscr...@googlegroups.com.
> 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 neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to