Couting word occurances in text

Couting word occurances in text

Post by Adrian Bilja » Wed, 04 Aug 1999 04:00:00

How can you count the occurances of a specific word in a column that is of
type text?

1. Query- Count how many occurances of certain text in a column

Hi everybody,

First time I've posted in this group so go easy on me :-). Hopefully
somebody can help. My website runs off an SQL database and I'm trying to
write a query in Microsoft SQL Query Analyser.

So, I've got a table called tbl_outgoing, and within it is a column called
number. A typical field contains text such as below:

There can be anything from 1 to 100+ <number>xxxx</number> entries in a
field. I need a query to count the amount of times <number> (or 'number'/2)
occurs in the whole column.

Chris Michael
Free ringtones/logos
Free mobile alerts
3 months free insurance

2. JOBS! - us-fl database administrator $45-60k.txt(1/1)

3. Full Text Indexing of Rich Text/ Word Documents

4. The weekly mini-FAQ about the Delphi newsgroups' reorganization

5. Beginners Question: couting to 81and then repeating.

6. US-OH-Columbus Software Engineer, C/C++, Java, CORBA, Oracle (1361-2150)

7. Couting Top 100 "Big" Tables

8. Assistance requested - Computer Telephony App

9. request help performing a query for single occurances

10. Number of occurances of a character in a string

11. Counting occurances of a string in a field..

12. Count occurances in a row

13. counting occurances of a string in a field