Entry

When using UPDATE where var = case , how can I make Mysql INSERT this row if it does not exist yet?

Jan 15th, 2002 00:36
Carsten Pedersen, tony dermont,

You probably want to use REPLACE rather than UPDATE/INSERT. This will 
replace any existing records having the same keys as your new data.