>>>> 2012/07/31 15:02 -0700, Haluk Karamete >>>> So, in a case like this
shop.orders.32442 shop.orders.82000 shop.orders.34442 It would be the record whose source_recid is shop.orders.82000. Why? Cause 82000 happens to be the largest integer. <<<<<<<< Now, if they are always 5-digit-long integers, try ending with ORDER BY SUBSTRING_INDEX(source_recid, '.', -1) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql