7 messages in com.mysql.lists.mysqlRe: Comparing x.x.x.x strings
FromSent OnAttachments
Lucas Vendramin24 Mar 2006 12:44 
Rhino24 Mar 2006 13:06 
Jay Paulson24 Mar 2006 13:13 
Dan Nelson24 Mar 2006 14:07 
Peter Brawley24 Mar 2006 18:26 
Lucas Vendramin27 Mar 2006 04:04 
Jake Peavy27 Mar 2006 12:07 
Subject:Re: Comparing x.x.x.x strings
From:Peter Brawley (pete@earthlink.net)
Date:03/24/2006 06:26:37 PM
List:com.mysql.lists.mysql

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