搜索引擎查询

Question

我想做搜索引擎。

当我从Band或Song_name开始时，我想要找到结果。但是这个查询只在我从Song_name开始时向我显示结果。这个查询有什么问题吗？

$query = "SELECT Band, Song_name FROM Songs WHERE 

CONCAT(Band,' ',Song_name) OR CONCAT(Song_name,' ',Band)

LIKE '".mysqli_real_escape_string($con, $search_text)."%'" ;

Answer 1

将WHERE语句更改为：

$query = "
    SELECT
    Band, Song_name
    FROM
    Songs
    WHERE 
    CONCAT(Band,' ',Song_name) LIKE '".mysqli_real_escape_string($con, $search_text)."%'
    OR
    CONCAT(Song_name,' ',Band) LIKE '".mysqli_real_escape_string($con, $search_text)."%'
";