IIRC, I think what you need may be in here somewhere: 12.7. Full-Text Search Functions
12.7.1. Boolean Full-Text Searches 12.7.2. Full-Text Searches with Query Expansion 12.7.3. Full-Text Stopwords 12.7.4. Full-Text Restrictions 12.7.5. Fine-Tuning MySQL Full-Text Search http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html Regards Keith On Wed, 12 Apr 2006, Taco Fleur wrote: > To: 'Dan Nelson' <[EMAIL PROTECTED]>, mysql@lists.mysql.com > From: Taco Fleur <[EMAIL PROTECTED]> > Subject: RE: Full text score > > Cool, > > Any idea why the following would return 0 each time as the score? > > SELECT MATCH (resumeAsText) AGAINST ('coldfusion javascript') > FROM db_au_com_exclaimit.tbl_resume > > The above returns 3 rows with 0 as score, the following > only 2 rows, meaning it actually does match two rows, but > does not display a score, any ideas anyone? Thanks in > advance. > > SELECT MATCH (resumeAsText) AGAINST ('coldfusion > javascript') FROM db_au_com_exclaimit.tbl_resume WHERE > MATCH (resumeAsText) AGAINST ('coldfusion javascript' in > boolean mode) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
