Entry

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

Feb 24th, 2008 00:21
dman, Carsten Pedersen, tony dermont, http://www.ttnr.org

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