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 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. -- -------------------------------------------- Tam McLaughlin IT Systems Administrator Scottish Legal Life Assurance Society Ltd _______________________________________________ Scottish mailing list [EMAIL PROTECTED] http://mailman.lug.org.uk/mailman/listinfo/scottish