KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
By default, SQL orders numbers before characters. So if I have the column "name": abc ab1 a1b 1ba 1bac b21 Since SQL sorts by 0-Z (first 0 to 9, then a-Z), the query SELECT * FROM ... ORDER BY name will result in: 1ba 1bac a1b ab1 abc abc1 b21 But I want it to sort by a-0 (first a-Z, then 0-9). abc abc1 ab1 a1b b21 1ba 1bac How do I do this in a query? More specifically, how do I do this in SQLite? I found one solution in Sort MySQL results alphabetically, but with numbers last , but only for first char.
Tags (comma-separated)
Save Edits
Cancel