SQLite Forum

Cannot select a value that matches another column name
Login
The post that starts that thread shows a misunderstanding of SQL.  Double quote characters indicate an entity name: a table name or a column name.  To specify a string you use apostrophes (single quote characters).  For instance, the line

<code>    SELECT * FROM Test WHERE Name = "Value";</code>

should be

<code>    SELECT * FROM Test WHERE Name = 'Value';</code>