Use SELECT DISTINCT. Matthew Scarrow ComIT Solutions Inc. www.comit.ca Phone: 519-442-0100 Fax: 519-442-0429
-----Original Message----- From: Kirk Babb [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 9:59 PM To: [EMAIL PROTECTED] Subject: help with MySQL SELECT statement Easy question I hope, relatively new user (< 6 months) here wanting to know how to fashion a MySQL select statement based on the following: there is a list of managers and their email addresses. This list changes all the time as we add and subtract different companies from the db. I would like to check the domain name of a form submitted email address against the list of domain names in the db. But I don't want to select the entire email list (1000's) when there are probably only 100 max different domain names (i.e. alltel.com, ualr.edu, etc.). Is there a way to do this? It would lighten the server load and the download times for the form page if possible. thanks! Kirk --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php