search for word - count the No of times it appears

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

search for word - count the No of times it appears

Author

Topic

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2001-12-11 : 20:20:54

Hi there,

I would like to count up the number of times a certain word appears in a text or varchar field to find out what is the most popular words. I know how to get the row count returned but I need to get the amount of times that word actually appears in each row and get a total.

thanks - Matt

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2001-12-11 : 20:31:00

Hey there

Have a look at this
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=10257

There might be something there you can use. If not, it's just plain amusing

Damian

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2001-12-11 : 20:33:13

Thanks Merkin - you're right, it is an amusing post!

byrmol
Shed Building SQL Farmer

1591 Posts

Posted - 2001-12-11 : 20:44:57

It certainly was an amusing post from my point of view..

I saw a post asking for this solution..
I answered it.
I went straight back to the home page and found basically the exact same question had been posted within 5 seconds of the first.
I replied with "Jinx"..

I think only "Sandesh" got it....

DavidM

A database is a set of axioms, the response to a query is a theorem, the process of deriving the theorem from the axioms is a proof, a proof is made by manipulating symbols according to agreed mathematical rules.

Edited by - byrmol on 12/11/2001 20:45:35

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2001-12-11 : 20:54:38

You obviously have deep emotional scars from that. I think you need a holiday David

Damian

A Database is a cool thing where I put some stuff.

byrmol
Shed Building SQL Farmer

1591 Posts

Posted - 2001-12-11 : 21:00:35

quote:

You obviously have deep emotional scars from that.

The therapist says they will heal shortly and that I should learn to control my anger.

To which I replied..

"You don't know what it is like working with databases that are not normalised, you f^&*%^&% idiot!"

quote:

I think you need a holiday David

Amen to that!!!!

DavidM

A database is a set of axioms, the response to a query is a theorem, the process of deriving the theorem from the axioms is a proof, a proof is made by manipulating symbols according to agreed mathematical rules.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources