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)
Kind regards,
Taco Fleur
Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox 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!
-----Original Message-----
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 12 April 2006 3:29 PM
To: Taco Fleur
Cc: mysql@lists.mysql.com
Subject: Re: Full text score
In the last episode (Apr 12), Taco Fleur said:
> is there such a thing as a score for full-text searches?
Sure. The MATCH function returns one.
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
