如何写"Select (all) From (table) Where posting=$posting except posting？“(Mysql)

Question

我想编写一个Mysql语句，它从一个表(Posting)中选择所有内容，除了标题$title之外，标题类似于$title。基本上，我想显示所有相关的帖子的某个帖子。我希望查询选择表中标题名称或详细信息中包含标题名称的所有发布。但我不希望在相关的帖子中显示该帖子。

//pseudocode
$query="Select * From posting Where title,detail, like %$title% except $title";

我该如何写例外部分？

Answer 1

这就是您需要的代码，不过如果您有当前的帖子id并且只有类似于WHERE id != " . (int)$current_post_id . "的内容，那么它会更好

$title = mysql_real_escape_string($title);

$sql = "
    SELECT *
    FROM posting
    WHERE
        title LIKE '%" . $title . "%' AND
        detail LIKE '%" . %title . "%' AND
        title != " . $title . "
    ";

这是ID版本，好多了:)

$title = mysql_real_escape_string($title);

$sql = "
    SELECT *
    FROM posting
    WHERE
        title LIKE '%" . $title . "%' AND
        detail LIKE '%" . %title . "%' AND
        id != " . (int)$post_id . "
    ";

Answer 2

编辑:如果您想要LIKE '%$title%‘和!= '$title’，则：

SELECT * FROM posting 
WHERE title LIKE '%$title%' AND detail LIKE '%$title%' AND title !=  '$title';

否则

SELECT * FROM posting 
WHERE title LIKE '%$title%' AND detail LIKE '%$title%' AND title NOT LIKE '%$title%';

你确定这是正确的吗？LIKE '%$title%' AND NOT LIKE '%$title%'是一个矛盾。