Muwatta Malik 1603
موطأ مالك#1603Sahihوَحَدَّثَنِي مَالِكٌ، عَنْ هِشَامِ بْنِ عُرْوَةَ، عَنْ أَبِيهِ، أَنَّ رَسُولَ اللَّهِ صلى الله عليه وسلم قَالَ " لاَ يَخْرُجُ أَحَدٌ مِنَ الْمَدِينَةِ رَغْبَةً عَنْهَا إِلاَّ أَبْدَلَهَا اللَّهُ خَيْرًا مِنْهُ " .
Malik related to me from Hisham ibn Urwa from his father that the Messenger of Allah, may Allah bless him and grant him peace, said, "No one leaves Madina preferring to live elsewhere, but that Allah will give it better than him in place of him
Scholarly Authentication
The label above is the grade most of these scholars gave — one dissenting opinion no longer speaks for all of them. If any scholar calls a narration fabricated, that verdict is shown instead, whatever the others say. Each scholar's own wording:
Salim al-HilaliSahih
In-book reference: 45:6