Not able to do escape query

Question

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'[-]...)"

Answer 1

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.