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.
--
--
On Tue, 28 Jan 2003 15:16:27 + 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
appologies (and feeling really silly right now)
this trivial question was not meant for this group.
I was just looking for a quick and lazy answer from a work
mate whos an informix 4gl answer so I could quickly test something.
On Tuesday 28 January 2003 3:16 pm, Tam McLaughlin wrote:
> i am tryi
select , count(*) from group by ;
--
From: Tam McLaughlin [SMTP:[EMAIL PROTECTED]]
Sent: 28 January 2003 15:16
To: [EMAIL PROTECTED]
Subject: [Scottish] sql
i am trying something in mysql but can't remember any sql.
Say i
Tam McLaughlin 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.
Ign
Try this --
SELECT COUNT(name) FROM table
WHERE name = "name";
Gary
> On Tue, 28 Jan 2003 15:16:27 + 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 se
Title: RE: [Scottish] sql
*
This email and any files transmitted with it are intended solely
for the use of the individual or entity to whom they are addressed