MySQL no numbers varchar sorting not working

Question

My attendee_lastname column definition: My sql:

SELECT attendee_lastname FROM oc_attendee ORDER BY attendee_lastname ASC

My Result:

I would expect lastname Abraham to be first? Any ideas?

I think that first letter is not latin 'A'. Check HEX(lastname). — Akina
– Akina, Commented Jun 21, 2023 at 9:02
Thank you Akina. Although that was not the problem, I did find the issue. The user typed a space before the last_name. So all those showing before Abraham had spaces in. — Quentinb
– Quentinb, Commented Jun 21, 2023 at 9:33

Quentinb · Accepted Answer · 2023-06-21 09:35:01Z

1

I found that the User typed in a space before their last_name. This resulted in all those starting with spaces to be first on the list and then the rest. After removing all spaces it works perfectly.

answered Jun 21, 2023 at 9:35

Quentinb

5101 gold badge11 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL no numbers varchar sorting not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related