Try this --
SELECT COUNT(name) FROM table
WHERE name = "name";
Gary
> On Tue, 28 Jan 2003 15:16:27 +0000 Tam McLaughlin <[EMAIL PROTECTED]>
> wrote :
>
> > i am trying something in mysql but can't remember any sql.
> > Say i have a field called name in table 1 and i want to select the
> > name and the number of times that name appears in the table,
> > how would i do it?
> > If u can tell me, i can find the equiv syntax in mysql
> > thanks.
>
>
_______________________________________________
Scottish mailing list
[EMAIL PROTECTED]
http://mailman.lug.org.uk/mailman/listinfo/scottish
