按结果排序？

Question

如果数据库中有单词nice car, nice, nice, nice car和我们搜索到的单词nice：如何按(列表)排序，如：nice, nice, nice car, nice car或如果搜索单词nice car 顺序由(列出)喜欢：nice car, nice car, nice, nice？

数据库中的nice car

• nice

• 单词：nice car，nice，nice，nice car => nice，nice，nice car，nice car

• nice car => nice car，nice car，nice，nice

我的问题是：

$find = $this->input->post('find');
    $where  =   "name LIKE '%$find%' OR 
            star LIKE '%$find%' OR
            address LIKE '%$find%'";
$query = $data['results'] = $this->db->query("SELECT @rownum:=@rownum+1 rownum, t.*
        FROM (
        SELECT *
        FROM my_table
        WHERE 
            $where
        ORDER BY id desc
        LIMIT $offset, $coun_page       
        ) t,
        (SELECT @rownum:=0) r");

Answer 1

MySQL不是搜索引擎。我强烈建议使用实际用于此任务的东西(例如Sphinx、Solr或Lucene)。