这是对我有用的查询-

SELECT m1.*
FROM messages m1 LEFT JOIN messages m2
 ON (m1.name = m2.name AND m1.id < m2.id)
WHERE m2.id IS NULL;

感谢@Shadow 提供指向可能重复的链接.

Thanks @Shadow for the link to the possible duplicate.