NYCPHP Meetup

[Timothy Boyden]

I don't have a code solution for you, but Google the CHECK and UNIQUE
predicates for the SQL language, I believe your answer lies within...

Also a good SQL reference book that has been a trusty partner for me is
the SQL Instant Reference by Sybex.


--------------------------- 
Timothy Boyden 
Network Administrator 
tboyden at supercoups.com 
  
SuperCoups(r) | 350 Revolutionary Drive | E. Taunton, MA 02718 
508-977-2034  | www.supercoups.com 
---------------------------

-----Original Message-----
From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org]
On Behalf Of Aaron Fischer
Sent: Thursday, December 07, 2006 10:10 AM
To: NYPHP Talk
Subject: [nycphp-talk] OT - MySQL select question

Greetings,

I'm not sure how to do the following, any tips?

I have a column in a MySQL table that contains varchars.  I would like
to select all records where there are instances of more than one record
for any given varchar.

So in plain language, the SQL statement would look something like:

select * from table where the occurence of each unique varchar in column
A is greater than one.

Thoughts?  Thanks!

-Aaron
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk

NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com

Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php