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

Deleting all items from the compare list in the database
You want or need help implementing this solution? Maybe you did not find what you were looking for? Contact me and I will assist you with whatever Magento problem troubles you!