SQLite “INSERT OR REPLACE INTO” vs. “UPDATE … WHERE”

UPDATE will not do anything if the row does not exist.

Where as the INSERT OR REPLACE would insert if the row does not exist, or replace the values if it does.