you can use lower(m.diseaseName) CONTAINS lower(disease)
instead of the regexp then you don't have to escape the regular expression special characters. Please note that this won't be a efficient lookup right now. On Tue, Feb 9, 2016 at 6:44 AM, Amber <[email protected]> wrote: > Hi all, > > I'm working on a project which aims to build a system to retrieve > biomedical information (e.g. biomedical entities such as drugs, diseases > and genes, and the relationships between them). When I tried to retrieve > the database to find a specific disease using a cypher statement: > > For cypher string "MATCH (m:Disease) WHERE m.disease_name =~ > '(?i)"+disease+"' RETURN m"; > > if the disease with a name of "2'-benzoyloxycinnamaldehyde" or > "4-[1-ALLYL-7-(TRIFLUOROMETHYL)-1H-INDAZOL-3-YL]BENZENE-1,3-DIOL" , > exceptions will occur with messages as follows: > > Invalid input '"': expected 0..9, '.', 'e', 'E', an identifier character, > whitespace, node labels, '[', "=~", IN, STARTS, ENDS, CONTAINS, IS, '^', > '*', '/', '%', '+', '-', '=', "<>", "!=", '<', '>', "<=", ">=", AND, XOR, > OR, LOAD CSV, START, MATCH, UNWIND, MERGE, CREATE, SET, DELETE, REMOVE, > FOREACH, WITH, RETURN, UNION, ';' or end of input (line 1, column 53 > (offset: 52)) > "MATCH (n1:Drug)-[x]-(n2:Disease) RETURN n1 LIMIT 25"" > > How could I fix this problem? Thank you so much! > > -- > 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.
