Mysql: Search Duplicate Entry Based on Column Value.

SELECT * FROM `tmm_sales_shipment_track` WHERE order_id IN (SELECT order_id FROM `tmm_sales_shipment_track` GROUP BY order_id HAVING COUNT(order_id) > 1) ORDER BY `created_at` ASC