$sql_1 = "SELECT url, author, title, body, ( MATCH (title,author) AGAINST ('$sql_search') ) + ( MATCH (body) AGAINST ('$sql_search' ) ) AS relevance FROM search WHERE MATCH (title, body,author) AGAINST ('$sql_search' IN BOOLEAN MODE) $sql_within HAVING relevance >0 ORDER BY relevance DESC"; /* for 50% threshhold avoidance and fuzzy matching*/ $sql_2 = "SELECT url, author, title, body, ( (1.3 * (MATCH(title,author) AGAINST ('$sql_search' IN BOOLEAN MODE))) + (0.6 * (MATCH(body) AGAINST ('$sql_search' IN BOOLEAN MODE))) ) AS relevance FROM search WHERE ( MATCH(title,body,author) AGAINST ('$sql_search' IN BOOLEAN MODE) ) $sql_within HAVING relevance > 0 ORDER BY relevance DESC";