Use contains with special symbols

Couchbase Server
,
1

{“schema”:{“type”:“string”,“optional”:false},“payload”:

DELETE FROM data AS d WHERE
CONTAINS(meta().id,"{“schema”:{“type”:“string”,“optional”:false},“payload”:");

Please suggest something right.

2

what is special symbols here ? https://www.json.org/json-en.html escape them

3

“ double quote . it is showing invalid string error.

4

Any quotes within same quotes (double inside double, single inside single) must use escape character as described here https://www.json.org/json-en.html

Alternative is single quote over double quote vice versa.

DELETE FROM  `data`  AS d WHERE
CONTAINS(meta().id,'{"schema":{"type":"string","optional":false},"payload":');