I am using sqlite virtual table (fts4) for open text search. I am trying to combine WHERE IN
and MATCH
to get my desired results. But the problem is that I am getting an error Error: database disk image is malformed
. Here is my sqlite query.
SELECT rowid,* FROM Alldata where FileMD5 IN ('9A9D70D3E2FF9388101EDF37EE87431A','A072C94BF828792D91052546C59D005B','A366E8C244D8DB0616900A61E5D90775') AND AllData MATCH 'contemporary*' limit 1000"
Aucun commentaire:
Enregistrer un commentaire