Michael, Actualy, my requirement was only MATCH (program:Program) WHERE program.genre =~ '(?i).*(*coo*).*' RETURN program.genre;
And this is for explaining the possibilities *coo|coc|tail|ler* I guess the above query wont be slow. -Sukaant Chaudhary <http://in.linkedin.com/pub/sukaant-chaudhary/33/ba8/479> On Tue, Dec 9, 2014 at 1:15 PM, Michael Hunger < [email protected]> wrote: > Best google for regexp tutorial. > > In general () is grouping, | is alternatives. > > But that kind of search won't be fast. > > MATCH (program:Program) WHERE program.genre =~ '(?i).*(*coo|coc|tail|ler*).*' > RETURN program.genre; > > probably better to index your genre via lucene as fulltext index and then > use lucene query syntax to find your programs. > > see: http://jexp.de/blog/2014/03/full-text-indexing-fts-in-neo4j-2-0/ > > On Tue, Dec 9, 2014 at 7:47 AM, Sukaant Chaudhary < > [email protected]> wrote: > >> Hi, >> I've the following data: >> >> neo4j-sh (?)$ MATCH (program:Program) RETURN program.genre; >> ==> +-----------------------------+ >> ==> | program.genre | >> ==> +-----------------------------+ >> ==> | "Coolers, Cocktail" | >> ==> | "Baking" | >> ==> | "Savoury Dish" | >> ==> +-----------------------------+ >> ==> 3 rows >> ==> 1 ms >> >> Now, Please help me to modify the following query: >> MATCH (program:Program) WHERE program.genre =~ '(?i)coc.*' RETURN >> program.genre; >> >> such that, >> >> >> >> *if I'll put program.genre = coo / coc / tail/ lerit should return >> "Coolers, Cocktail"* >> >> *or if I put program.genre = Sav / Di / Dish / Savouryit should return >> "Savoury Dish"* >> >> -Sukaant Chaudhary >> <http://in.linkedin.com/pub/sukaant-chaudhary/33/ba8/479> >> >> -- >> 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. > -- 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.
