Database, MySQL

Get duplicate row in Mysql

SELECT profile_id, count(profile_id) FROM `wp_profile_list`  WHERE 1 GROUP BY profile_id HAVING COUNT(profile_id) > 1;

Leave a Reply

Your email address will not be published. Required fields are marked *