[Impressum/Imprint] [Kontakt/Contact Me]
Home Working with TNG's SQL-based Reports (A Guide to my Report Library) Adding Additional Indexes To Your TNG Database Tables Understanding SQL Select Statements
 TNG - Tips & Tricks
 Working with TNG's SQL-based Reports (A Guide to my Report Library)

Some More SQL Tips & Tricks


Sorting by ID – as a Number, not as a Word

If you run something like

SELECT * FROM tng_people ORDER BY personID LIMIT 10;,

you get a result list with I10, I100, I1000, I10000 and so on. For sorting by ID as a number, use

...ORDER BY CAST(SUBSTRING(personID, 2) AS UNSIGNED)...

instead. (SUBSTRING deletes the first character ("I"), CAST converts the remaining string into a number.)


Copyright © http://www.ahnendaten.de/tng/
Letzte Aktualisierung am 11. Juni 2017

Home Working with TNG's SQL-based Reports (A Guide to my Report Library) Adding Additional Indexes To Your TNG Database Tables Understanding SQL Select Statements