Ole Kasper Olsen wrote:
Hi,
I have a database column (VARCHAR) consisting of the following kind of
data:
1
1.1
1.2.1.2
1.10.1
1.2
1.4.1
I need to sort this colum so that the result will be
1
1.1
1.2
1.2.1.2
1.4.1
1.10.1
I was hoping that just using "ORDER BY [column] ASC" would work, but
alas,
Hi,
I have a database column (VARCHAR) consisting of the following kind of
data:
1
1.1
1.2.1.2
1.10.1
1.2
1.4.1
I need to sort this colum so that the result will be
1
1.1
1.2
1.2.1.2
1.4.1
1.10.1
I was hoping that just using "ORDER BY [column] ASC" would work, but alas,
it only works for numbe
sort strings as
> numbers ?
> Because, when i sort the records, the order is always 1.1.1.1; 1.1.1.10;
> 1.1.1.2. (which is correct if i'm sorting strings...)
> But i need the result : 1.1.1.1; 1.1.1.2; 1.1.1.10...
>
> There is no possibility to change the IP-
Hi,
I have some large tables, which contain also IP-Adresses as strings.
Is there any workaround (which uses MySQL-functions) to sort strings as
numbers ?
Because, when i sort the records, the order is always 1.1.1.1; 1.1.1.10;
1.1.1.2. (which is correct if i'm sorting strings...)
But i nee
