SQL Question
| From: | Kevin Diffily | Date: | Wed, 13 Mar 2002 19:05:24 +0000 |
| Subject: | SQL Question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17654@lists.php.net to get a copy of this message | ||
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