ON DUPLICATE KEY UPDATE

I know this isn't standard SQL but can anyone give me some advice on whether to use this or not? It's tempting because of its convenience.

I am wondering if it falls along the same lines as never using the "dreaded evil enum"?

not even close to that

go ahead and use it, it is simpler than not having it available

That's Great News. Thanks Rudy!