清理空文档指定字符
delete FROM v9_collection_content
WHERE nodeid
= 15 AND status
= 1 AND data
LIKE ‘%“content”:“”%’ ORDER BY nodeid
ASC
DaTA字段为空
delete FROM v9_collection_content
WHERE nodeid
= 15 AND status
= 1 AND data
= null ORDER BY nodeid
ASC
Data字段指定内容
delete FROM v9_collection_content
WHERE nodeid
= 15 AND status
= 1 AND data
LIKE ‘%%’ ORDER BY nodeid
ASC
参考网址:添加链接描述