drooh - 9:35 pm on Jul 5, 2011 (gmt 0)

Ok, thank you, I wish they could write their examples like that. For some reason that mysql website is just so hard for me to read.

Somehow

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name
SET col_name={expr | DEFAULT}, ...
[ ON DUPLICATE KEY UPDATE
col_name=expr
[, col_name=expr] ... ]

Just doesnt register in my brain.

thanks for you post and letting me know this is possible.