Hello,
what you want to achieve is called "natural order sorting" which is not
built into any common SQL implementation I know. You have to do it manually
from code, or, if you have to do pagination, add a sorting column that is
numeric (and indexed).
Best,
Gergely
On 28 Sep 2015 08:42, "gintare"
Is it possible to order the query result strings in such a way that th128
string would be first comparing to th99.
The query results contains 128 items in format: "th"+number. For instance,
th1, th2, ...th80, ..th99, th100, th128.
Than i order results, they go in the following order, th1, th10,th
2 matches
Mail list logo
