LEFT JOIN，ORDER BY和分页

Question

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?

Answer 1

I see your sorting is case sensitive. Change your ORDER BY to the following:

SELECT
    s.*
FROM
    structure s
    LEFT JOIN typologie t ON s.id_typologie = t.id_typologie 
    LEFT JOIN pays p ON s.id_pays = p.id
ORDER BY
    LOWER(s.nom_contact) ASC

That should fix your problem.