iam new to cassandra, i want to do get query using cassandra python client? iam not able to escape special characters.can anyone help Below is the query which iam trying, but getting syntax error
SELECT pmid FROM chemical WHERE mentions=$$ N,N'-((1Z,3Z)-1,4-bis(4-methoxyphenyl)buta-1,3-diene-2,3-diyl)diformamide $$ AND pmid=31134000 ALLOW FILTERING;
it is giving me error Error from server: code=2000 [Syntax error in CQL query] message="line 1:118 mismatched input '-' expecting ')' (...,source) VALUES ('be75372a-c311-11e9-ac2c-0a0df85af938','N,N'[-]...)"