The elements of my list are not displayed in alphabetical order. This list is displayed page by page (pagination : page 1, page 2, page 3 ....).
I used ORDER BY
but my request returns false results.
SELECT * FROM structure
LEFT JOIN typologie
ON structure.id_typologie = typologie.id_typologie
LEFT JOIN pays
ON structure.id_pays = pays.id
ORDER BY nom_contact ASC
Examples with the data:
zone attente Roissy
AP-HP (Archives de)
AP-HP bureau recherches
Apprentis d'Auteuil MECS Saint-Jean Eudes
APTIRA
Caroline Chateau
Château de la Villette
Chivilo (Mme)
CICR Genève
CICR Kinshasa
Where is the problem?