From: jonathan michaels Date: April 8 1999 12:06am Subject: Re: Selecting top level domains List-Archive: http://lists.mysql.com/mysql/1505 Message-Id: <19990408100634.C11782@caamora.com.au> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii On Sun, Apr 04, 1999 at 12:49:15PM +0100, Adam Powell wrote: > > Hi there, I wish to write a SELECT statement to process a list of urls > (without the leading http://) to find top level domains, ie those like > www.something.com, www.somethingother.net, and not those with a subdirectory > such as www.something.com/mypage. What is the syntax of doing this? I have > tried a few things but cannot get it to work. www.some.domain.com.au you might need to watchout for tld's that are outside teh american sphere of delegation .. just a warning. it can make sorting a real mess, especially if its related to ecommerce and such like. regards jonathan -- =============================================================================== Jonathan Michaels PO Box 144, Rosebery, NSW 1445 Australia ===========================================================