MYSQL全文搜索的相关性 [英] MYSQL fulltext search order by relevance
本文介绍了MYSQL全文搜索的相关性的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试按相关性对我的全文搜索进行排序.这是我的代码,如果删除ORDER BY但不按相关性排序,则可以正常工作.我已经尝试过了,它确实做到了,所以根本找不到任何结果...有任何想法吗?
I am trying to get my Full text search to order by relevance. here is my code it works if remove the ORDER BY but doesn't sort by relevance. I have tried this and it actually makes it so it doesnt find any results at all... Any ideas?
$query_for_result=mysql_query("
SELECT * FROM Assets WHERE MATCH
(`Badge`,`First Name`,`Last Name`,`Service Tag`,`Asset Tag`)
AGAINST ('".$query."*' IN BOOLEAN MODE) and
`deleted` = '0' ORDER BY relevance DESC");
编辑*
<input type="text" name="query" />
<input type="hidden" value="Search" name="submit" />
<input type="submit" name="submit" value="Search" />
</form>
<h4>Search by: Badge, First or Last Name, Service Tag, Asset Tag, Printer Queue or Printer IP.</h4>
<br>
</center>
<?php
if(isset($_GET['submit'])){
$db_tb_name=Assets;
$db_tb_atr_name=`First Name`;
$query=mysql_real_escape_string($_GET['query']);
$query_for_result=mysql_query("
SELECT * FROM Assets WHERE MATCH
(`Badge`,`First Name`,`Last Name`,`Service Tag`,`Asset Tag`)
AGAINST ('".$query."*' IN BOOLEAN MODE) and
`deleted` = '0' ORDER BY relevance DESC");
然后在代码中
while($data_fetch=mysql_fetch_array($query_for_result))
{
print '<h3>';
print "<a href=\"modify.php?id=" . $data_fetch['id'] . "\">" . $data_fetch['First Name'] . ' ' . $data_fetch['Last Name'] . "</a>";
print '<br/><b>Badge:</b> '. $data_fetch['Badge'];
print '<br/> <b>Service Tag:</b> '. $data_fetch['Service Tag'];
print ' <b>Asset Tag:</b> '. $data_fetch['Asset Tag'];
print '<br/> <b>Status:</b> '. $data_fetch['Status'];
print '<br/><b>Employee Status: </b>';
if( $data_fetch['Employee Status'] == 'Active' ){
print '<font color="#32CD32">' . $data_fetch['Employee Status'] . '</font>';
}
elseif( $data_fetch['Employee Status'] == 'Terminated' ){
print '<font color="red">' . $data_fetch['Employee Status'] . '</font>';}
print '<br/> <b>Last Modified:</b> '. $data_fetch['Last Modified'];
print "<span> </span>";
print '</h3>';
print '<br/><p>' ;
}
更新 这对我有用 我终于通过使用
UPDATE This worked for me I finally got it working by using
$query_for_result=mysql_query("SELECT *, MATCH
(`Badge`,`First Name`,`Last Name`,`Service Tag`,`Asset Tag`)
AGAINST ('".$query."'IN BOOLEAN MODE) AS Relevance FROM Assets WHERE 1 AND MATCH
(`Badge`,`First Name`,`Last Name`,`Service Tag`,`Asset Tag`)
AGAINST ('".$query."' IN BOOLEAN MODE) and
`deleted` = '0' ORDER BY Relevance DESC ");
推荐答案
查看全文