php - 如何查询 SELECT name FROM movie WHERE Category LIKE :search - with adding some string before and after SEARCH

Question

我有疑问:

SELECT name FROM movies WHERE category LIKE :search

我在列类别中有多个 ID:1,81,23为了更好地搜索，需要在查询中的 :search 的开头和结尾添加逗号，例如 ',1,81,23,' 以搜索模式 ',XX,' 中的特定 id

$stmt = $this->db->prepare('SELECT name FROM movies WHERE category LIKE :search');
$stmt->bindValue(':search', "%$search%", PDO::PARAM_STR);
$stmt->execute();
return $stmt->fetchAll(PDO::FETCH_ASSOC);

需要查找单个ID

Answer 1

SELECT DISTINCT b.name
FROM(
      SELECT 'searchString' AS Keyword
      FROM movies
    ) AS a 
INNER JOIN movies AS b
ON a.Keyword like '%'+b.category+'%'

将您的用户输入放入“searchString”中，就可以了。当输入',1,18,23,'时，会显示3条记录。