[Scottish] sql

[Gary Campbell]

Try this --

	SELECT COUNT(name) FROM table
	WHERE name = "name";


Gary


> On Tue, 28 Jan 2003 15:16:27 +0000 Tam McLaughlin <tamm@scotlegal.com>
> 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.
> 
>