Hi, You can just do SELECT MATCH(column name) AGAINST ('searchstring') AS relevance FROM tablename;
There is an example at: http://www.mysql.com/doc/F/u/Fulltext_Search.html Gurhan -----Original Message----- From: Mouratidis [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 6:38 AM To: [EMAIL PROTECTED] Subject: Results relevance Anybody knows how to get a percentage out of the Relevance Mysql returns when queried with the match() function? I am using Perl, so if there are any scripts or modules that you know of, those are also welcome. Alex --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php