SQLite Forum

adding record if it doesn't already exist
Login
Add a unique index to table1 on email, then do <code>INSERT OR IGNORE INTO "table1" ("email") VALUES ('email@addre.ss');</code>