$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";