删除 post_id = PEzQo82KYTLLoXw AND `PEzQo82KYTLLoXw#

Question

我有一个包含以下示例的表我需要删除两者，但问题是我只有帖子 ID：“PEzQo82KYTLLoXw”作为参数，即使有评论，如何删除两者？post_id#commentPEzQo82KYTLLoXw#comment_id虽然这是我的查询$p_id = "PEzQo82KYTLLoXw";$likes = $pdo->prepare('DELETE FROM likes WHERE post_id = :like_p_id');$likes->bindParam(':like_p_id',  $p_id);$likes->execute();由于评论是随机的，如何同时删除与其相关的所有评论？`PEzQo82KYTLLoXw#comment_id`

Answer 1

您需要一个 LIKE 子句来匹配 pid 的模式

      $p_id = "PEzQo82KYTLLoXw";

    $likes = $pdo->prepare('DELETE 

          FROM likes WHERE post_id like

            Concat( :like_p_id,'%');

            $likes->bindParam(':like_p_id',  

       $p_id);

     $likes->execute();