我目前正在处理一个必须显示特定表中所有文章列表的查询,但它必须根据搜索表单对列表进行排序,以便首先显示包含最多/最佳匹配的文章,然后显示根本没有任何匹配将按字母顺序排序.

我已经使这个代码工作得很好,虽然我找不到按大多数匹配/相关性对匹配进行排序的方法.

这是我的代码：

$seArch = $_POST["searhwords"];
$search = PReg_replace('/\s+/',' ',$search);

$SearchQueryArray = str_replace(",","",$search);
$SearchQueryArray = str_replace(" ",$SearchQueryArray);
$SearchQueryArray = explode(',',$SearchQueryArray);


$outputtt1 = '';
$outputtt2 = '';
foreach ( $SearchQueryArray as $queryword )
{
    $outputtt1 .= "tITle LIKE '%".$queryword."%' OR ";  
    $outputtt2 .= "title NOT LIKE '%".$queryword."%' AND ";  
}

$outputtt1 = rtrim($outputtt1,' OR ');
$outputtt2 = rtrim($outputtt2,' AND ');




$query_for_result = MysqL_query("SELECT * From mytable 
WHERE ".$outputtt1."
union all
SELECT * from mytable 
WHERE ".$outputtt2."
");

所以我需要找到一种方法来对包含匹配项的文章进行排序,以便首先对包含大多数匹配项的文章进行排序.

你可以看到我在这里制作的剧本：
http://www.genius-webdesign.com/test/querytest.php

select t.*
from mytable
order by ((title like '%keyword1%') +
          (title like '%keyword2%') +
          (title like '%keyword3%') +
          . . .
          (title like '%keywordn%')
         ) desc;

order by ((length(replace(title,'keyword1','x')) -
           length(replace(title,'')
          ) +
          (length(replace(title,'keyword2','')
          ) +
          . . .
          (length(replace(title,'keywordn','')
          )
         );