Re: [sqlite] one SQL statement that will insert a new row in a table if a certain string is not found in a column?

[D. Richard Hipp]

On Tue, 2005-01-25 at 09:05 -0700, Dennis Cote wrote:
> [REPLACE] works as long as the column containing the string you want to 
> search 
> for is the primary key of the table (like user above). If the primary key 
> doesn't exist, it does an insert. If it does, it replaces that row with the 
> new values.
> 

A technical point:  REPLACE also works if there is a UNIQUE index
or a UNIQUE constraint on the column containing the string you are
inserting.