you can also convert the ip to an ip number and store it that way. makes it easier so you don't have do deal with a octete'd number
:) > -----Original Message----- > From: Hassan Schroeder [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 23, 2003 1:57 PM > To: MySQL Mailing List > Subject: Re: IP Address Operations in MySQL > > > Aaron Clausen wrote: > > > I'm running 3.23.49 on a Win2k machine and wonder if anybody has > > some advice on how to write queries dealing with IP addresses. > > Specifically, I have a table with an ip address field. I want to > > be able to do queries based on subnet. Has anybody got anyting > > like this? > > Yes, REGEXP / RLIKE will work fine for this -- for example: > > SELECT hostname, ip FROM addr WHERE ip RLIKE '^192.168.10.[0-9]+$'; > > HTH! > -- > Hassan Schroeder ----------------------------- [EMAIL PROTECTED] > Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com > > dream. code. > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
