MySQL ON DUPLICATE KEY insert into an audit or log table

[fisherman1]

Is there a way to accomplish this?\[code\]INSERT IGNORE INTO some_table (one,two,three) VALUES(1,2,3)ON DUPLICATE KEY (INSERT INTO audit_table VALUES(NOW(),'Duplicate key ignored')\[/code\]I really don't want to use PHP for this Thanks!