NYCPHP Meetup

[edward potter]

yipes!   Kung Fu programming!

"I believe your answer lies within..."

:-)  ed

On 12/7/06, Timothy Boyden <tboyden at supercoups.com> wrote:
> 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
> _______________________________________________
> 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
>


-- 
the Blog: http://www.utopiaparkway.com
the Karma: http://www.coderswithconscience.com
the Projects: http://flickr.com/photos/86842405@N00/
the Store: http://astore.amazon.com/httpwwwutopic-20