What are the limitations on using INSERT when you suspect a particular entry might already exist?
Here's an example.
table names
nameid int
name varchar
namecomments mediumtext
I want to be able to distribute the updated library of names which does not overwrite namecomments for people who have changed them from the default.
It occurs to me as I write this it could be done by making name a unique field, but what would mysql do then? Ignore the query? I only want to query to now be performed if an identical entry in name already exists.
