I have a table that has a ton of data in it, about 140,000 rows. now lets say that this data has many columns that contain a set of data that is exactly the same. For example, 25,000 rows contain the field 'ip' with the value 127.0.0.1 ... I need to be able to QUICKLY fly through all the data and have it return the number of rows that contain that same info, all dynamic. So that it will just show, maybe 12 rows, and show 'repeated 400 times' or somthing like that. Is there a mysql query that will do that, or does anyone have any suggestions. It needs to be quick, very quick. What I am doing now will not work, its a normal "show * from table where ip like '%$this%'" and it is in a for() loop that checks each unchecked piece of data for the number of entries. As you can guess that takes an eternity.
counting duplicate data
- Thread starter wxdqz
- Start date