HOW TO SEACRH FOR WORDS IN DATABASE

dextergaisie · May 14th, 2007, 10:24 AM

HELLO I NEED HELP ON HOW TO SEARCH FOR NUMBER ENTERIES OF A PARTICULAR WORD IN A DATABASE.
THAT IS THE NUMBER(A PARTICULAR WORD) ARE WITHIN A DATABASE.
SO AS TO ENABLE ME MAKE STATISTICS OF ENTRIES...
THNAK YOU. SAM

dparsons · May 14th, 2007, 10:31 AM

Something like this should work:

SELECT count(myColumn) from table where Contains(myColumn, 'Search Text')

Also do a google search on: Full Text Search. This should help you.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

gbianchi · May 14th, 2007, 10:33 AM

hey there...

with some tunning this could help you:

Code:

SELECT COUNT(*) FROM Table_name WHERE field LIKE '%word_to_look_for%'

depending on your database % should be *.
Also replace red with your information...

This will count the number of rows that has your specific search. but if you want the numbers of entries inside a specific field you will need to use another way around...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

BrianWren · May 14th, 2007, 01:55 PM

Say dextergaisie:
When you use all capital letters, it has the effect of shouting. To compound that by using bold as well makes your post hard to readâhard on the eyes.

Please observe the way the answers you got are formatted, and try to post questions formatted similarly.

dextergaisie · May 15th, 2007, 05:50 AM

Quote:

quote:Originally posted by BrianWren
Say dextergaisie:
When you use all capital letters, it has the effect of shouting. To compound that by using bold as well makes your post hard to readâhard on the eyes.

Please observe the way the answers you got are formatted, and try to post questions formatted similarly.

OK.Thamks for the advice.
Best regards dextergaisie.