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.