delete specific column duplicate data in mysql

I have a mysql table site_visitor with vid(auto_increment),IP,page,visit_time… columns, the problem is many duplicate IP data in the table, only the IP column data is duplicated while the others like isp,visit_time… are not, i did much test and finally find a very simple way.

Read the rest of this entry »