sql_newbie wrote:
> rc = sqlite3_exec( db, "DELETE FROM urls", NULL, NULL, &zErrMsg );
>
> The previous code will delete everything in the "urls" table and this
> is not what i want.
> I have a string Array "MyURLsArray" which contains 20 URLs as
> strings. My question is:
>
> How can i format the SQL query so that, it will delete all the
> entries in "urls" table, but keep the entries that match the strings
> stored in the string Array "MyURLsArray" ?
delete from urls
where url not in ('url1', 'url2', ..., 'url20');
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
