adding a record only if it doesn't already exist

[rebred]

I'd like to add a name to the DB only if it's not already in the DB

if the record is already in the DB I'd like to answer 'sorry the record already exists'

`
CREATE TABLE IF NOT EXISTS users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL
);
INSERT INTO users (name)
SELECT :name WHERE :name IS NOT NULL;
SELECT name AS title FROM users;
SELECT 'form' AS component, 'Add name:' AS title;
SELECT 'name' AS name, TRUE AS required;

`