How to delete record from table where field is equal to header?
<p>I have a sqlite table which contains duplicate headers which I would like to remove. This is my current statement.</p>

<pre><code>DELETE FROM table WHERE FIELD = "FIELD"
</code></pre>

<p>This statement, when executed, deletes the entire table.</p>

<p>Don't use double quotes for strings!</p>

<pre><code>delete from table where field = 'field';
</code></pre>

<p>The SQL standard for string delimiters is single quotes.  Sometimes double quotes are used, but they are also used as escape characters for column names.  So your code was just <code>where field = field</code> and that deletes all non-NULL values.</p>

python sql sqlite sql-delete