RE: [PHP-DB] SQL Question

you can do it by using distinct function .. Do: SELECT DISTINCT(city) FROM addresses; Gurhan -----Original Message----- From: Kevin Diffily [mailto:kevin@inetws.net] Sent: Wednesday, March 13, 2002 2:05 PM To: php-db@lists.php.net Subject: [PHP-DB] SQL Question Hello, I have a simple SQL Question. I would like to take the column city in database addresses and find out which cities are available in it. In other words if the following values are in there: city El Paso Burlington New York New York El Paso Burlington I would like it to return El Paso New York Burlington I know that it would something like SELECT city FROM addresses WHERE ?????? Thanks Kevin Diffily InterNetWorkingSolutions Enterprise Class Solutions for All Enterprises 318 Last Road, Cabot, VT 05647 USA VOICE: 1.866.inetws.net (Toll Free) FAX: 1.888.726.9030? (Toll Free) Sales: sales@inetws.net General Information: info@inetws.net Website Hosting: hosting@inetws.net Systems Administration Services: systemsadmin@inetws.net Technical Support & Training Services: training@inetws.net Shop For it On Amazon: http://kevin.inetws.net/amazon Instant Messaging Username: AIM, IRC, Jabber, MSN, Yahoo: inetwsnet ICQ: 120778694