cidaris has asked for the wisdom of the Perl Monks concerning the following question:

Does anyone have experience with using "ON DUPLICATE KEY UPDATE" with DBI and MySQL? I've been having a number of problems, but was hoping maybe someone could post a brief snippet of how they do it before I go into depth. As usual, I'd rather do it the hard way than have someone fix it for me ;)

Thanks in advance.