You are misusing quotes. Double quotes are for names that contain whitespace. Neither your table name nor any of the column names require them. Sometimes SQLite will accept a literal enclosed in double quotes, because doing so makes sense in the context and SQLite is being nice. For best results, don't use double quotes unless you are being force fed multi word table and/or column names. Single quotes are for string literals. Always use single quotes for string literals. Also, comparing NULL to anything results in NULL, which is NOT TRUE. Check out the IS operator. BTW: VARCHAR(36) is read as type TEXT, check https://sqlite.org/datatype3.html