SQLite Forum

content of field must not be identical to another column name of same table for UPDATE SET to work
Login
Unfortunately, this is the way it is. Use single-quotes for string literals.

[](https://www.sqlite.org/quirks.html#double_quoted_string_literals_are_accepted)