From: Peter Brawley
Date: March 25 2006 2:27am
Subject: Re: Comparing x.x.x.x strings
List-Archive: http://lists.mysql.com/mysql/196152
Message-Id: <4424AA74.2040502@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

 >When I compare two strings in mask (x.x.x.x) the comparation is not 
true (for my question :D)... look:
 >select '3.2.0.13' > '3.2.0.2'            -> FALSE
 >I want this command return TRUE, but it is returning FALSE.

select inet_aton('3.2.0.13') > inet_aton('3.2.0.2');
+----------------------------------------------+
| inet_aton('3.2.0.13') > inet_aton('3.2.0.2') |
+----------------------------------------------+
|                                            1 |
+----------------------------------------------+

PB
>