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'[-]...)"
Based on the Syntax Provided as i see there is a Single quotes missing in your Query . 
Suggestion 
Note to use ALLOW FILTERING  as it will Scan your Table which will be a performance issue.
Not able to do escape query