Re: [Scottish] sql
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 can tell me, i can find the equiv syntax in mysql thanks. Maybe you should read the fine manual for mysql at http://www.mysql.com/documentation/index.html --- Kenny Duffus /~\ The ASCII Department of Computer Information Sciences\ / Ribbon Campaign University of Strathclyde, Glasgow, UKX Against HTML Tel: +44 (0)141 548 3592Fax: +44 (0)141 552 5330 / \ Email! ___ Scottish mailing list [EMAIL PROTECTED] http://mailman.lug.org.uk/mailman/listinfo/scottish
RE: [Scottish] sql
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. * 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. No exactly sure if you;re after the number of times the value name appears in the name of a field or whether a field name has a value whatever x number of times Assuming the latter select count(*) as 'no_of_times' from table1 where name = 'whatever' last one can be where name like '%whatever%' if you want to find the value anywhere in the string cds