Learn How to Reset the 'Hits' Counter in Joomla 1.5, 2.5 and later versions

Step 1: Open PHPMyAdmin

Step 2: Click on your database name at left.

Step 3: Click on the 'SQL' Tab

Step 4: Enter the following SQL command:

           "update jos_content set hits=0"   and click GO. And that's done.

If you are using Joomla 2.5 or a later version, enter the following SQL command

            "update abc_content SET hits = 0"

Note: Replace 'abc' with your table prefix.

This is how to reset the Hits Counter in Joomla. Hope you found this information useful.