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.