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
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 ;-)
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!