Re: SQL SELECT with Similar Terms -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.