List:General Discussion« Previous MessageNext Message »
From:Taco Fleur Date:April 10 2006 9:37pm
Subject:counting keywords
View as plain text  
Hi all,
 
I am trying to find out whether it is possible to return the count of
keywords found in a text field, does anyone know?
For example; "ColdFusion or Java" is entered in the search string and 20
records are found that match, I need to count how many times "ColdFusion"
and "Java" appears in each match, add those two and than sort descending on
that total.
 
I was actually using verity for the search, but the client insists he sees
the number of keywords found, which Verity does not do.
 
The text searched are Résumé's, I initially thought that MySQL could search
the résumé's when stored as binary data, but I was wrong, so I now have the
CV's converted to HTML and then store them in the DB as VARCHAR
 
Any help would be much appreciated, I am having a hard time coming from a MS
SQL background ;-)
 
Kind regards,
 

Taco Fleur 

Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox  <http://www.pacificfox.com.au/> http://www.pacificfox.com.au an
industry leader with commercial IT experience since 1994 …

*	

	Web Design and Development 
*	

	SMS Solutions, including developer API
*	

	Domain Registration, .COM for as low as fifteen dollars a year,
.COM.AU for fifty dollars two years!

 


Thread
counting keywordsTaco Fleur10 Apr
  • Re: counting keywordsSteve Edberg11 Apr
RE: counting keywordsTaco Fleur11 Apr
  • RE: counting keywordsSteve Edberg11 Apr
RE: counting keywordsTaco Fleur12 Apr
  • RE: counting keywordsSteve Edberg12 Apr