mysql full text strangeness
Posted: Mon May 18, 2009 11:55 am
I am having a problem with fulltext search of the database. It works 99% of the time but in some cases returns a 0 set of results when it should not. Is this a case of mysql reserved words or is there something else I am missing?
The Search for "changes" returns 0 results even though it is mentioned in name and keywords. Other searches for other words in keywords and this record shows fine.
Thanks in advance for help
Code: Select all
$search = mysql_real_escape_string($_GET['search']);
mysql_select_db($database_db_connect, $db_connect);
$query_basic = "SELECT *, MATCH(name, keywords) AGAINST ('$search' IN BOOLEAN MODE) AS relevance FROM businesses WHERE MATCH(name, keywords) AGAINST ('$search' IN BOOLEAN MODE) and level='1' group by address1 order by relevance DESC";
$basic = mysql_query($query_basic, $db_connect) or die(mysql_error());
$row_basic = mysql_fetch_assoc($basic);
$totalRows_basic = mysql_num_rows($basic);
Thanks in advance for help