The following MySQL query deletes all rows from the Magento compare list table.

Deleting all items from the compare list in the database
Need help implementing this solution, or still looking for a fix to your Magento problem? Get in touch and I will be happy to help with your project.
Tags: