Re: SQL SELECT with Similar Terms

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

But that wouldn't make Rattan and :Rattan: show up as the same result, would it?

On 8/17/07, lgoodbar@xxxxxxxxxxxxxx <lgoodbar@xxxxxxxxxxxxxx> wrote:
> Short method (untested):
> Select distinct(name), count(name) from file
>
> Longer method:
> Select name, count(name) from file
> Group by name
>
> Loyd Goodbar
> Senior programmer/analyst
> BorgWarner
> TS Water Valley
> 662-473-5713
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael Ryan
> Sent: Friday, August 17, 2007 08:18
> To: Midrange Systems Technical Discussion
> Subject: SQL SELECT with Similar Terms
>
> Anyone know how to do this? I have data that looks like this:
>
> Rattan
> Traditional
> :Rattan:
> Contemporary
>
> I'd like to produce a list like
>
> Rattan 2
> Traditional 1
> Contemporary 1
>
> The 'extra' search result with the colons around it should be the same
> as the search result without the colons.
>
> Thanks...
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.