INSERT OR REPLACE does this. http://www.sqlitetutorial.net/sqlite-replace-statement/