SQLite delete from table where field does not match an object in an array

Question

Say I have a table with an ID field, and I have a local array (in any language, php or objective c or basic or whatever) of eligible IDs. I want to delete any record in which the ID field does not match any of the eligible IDs in my array.

Is there any way to do this in a single SQL query? Can you pass an array into SQL and basically say delete from sometable where 'id' is not in 'arrayofids'?

Thanks for any help. I've looked into the help docs but SQLite/SQL aren't one of my best skills.

mjdth · Accepted Answer · 2010-02-26 05:53:23Z

4

I think I've already found the answer:

$locationSQL = "DELETE * FROM item WHERE 'ID' NOT IN ($somearray)";

And you simply use commas to separate the items of the array. Simple enough.

answered Feb 26, 2010 at 5:53

mjdth

6,5466 gold badges41 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

D.Rosado Over a year ago

The character '*' is not valid in SQLite.

Collectives™ on Stack Overflow

SQLite delete from table where field does not match an object in an array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related