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,
Check the misc. functions section in the users manual 7.4.12 or thereabouts.
Specifically INET_NTOA() and INET_ATON().
[EMAIL PROTECTED] wrote:
> Hi,
>
> I have some large tables, which contain also IP-Adresses as strings.
> Is there any workaround (which uses MySQL-functions) to sort strings a
