DELETE where post_id = PEzQo82KYTLLoXw AND `PEzQo82KYTLLoXw#comment_id` random

Question

I have a table that has the following example

I need to delete both but the problem is that I have only post id: "PEzQo82KYTLLoXw" as parameter, how to delete both even when it has a comment?

post_id#comment

PEzQo82KYTLLoXw#comment_id

For while this is my query

$p_id = "PEzQo82KYTLLoXw";
$likes = $pdo->prepare('DELETE FROM likes WHERE post_id = :like_p_id');
$likes->bindParam(':like_p_id',  $p_id);
$likes->execute();

since the comment is random, how to also delete all comments linked to it ?

`PEzQo82KYTLLoXw#comment_id`

Himanshu · Accepted Answer · 2019-09-12T18:40:10.700

0

You need a LIKE clause to match the pattern of 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();

edited Sep 12 '19 at 18:40

answered Sep 12 '19 at 18:38

Himanshu

3,830
2
10
29

You have errors in your code! – Nigel Ren Sep 12 '19 at 18:39
Syntactically maybe but I was trying to denote pattern matching via like clause updated with concat now – Himanshu Sep 12 '19 at 18:41
i am trying to select before delete, `SELECT * FROM `likes` WHERE `post_id` LIKE Concat('PEzQo82KYTLLoXw %')` selects nothing – Otávio Barreto Sep 12 '19 at 18:43
ohh got it `SELECT * FROM `likes` WHERE `post_id` LIKE Concat('PEzQo82KYTLLoXw', '%')´ – Otávio Barreto Sep 12 '19 at 18:44
Yeah.. Does that help? – Himanshu Sep 12 '19 at 18:46
yeah, please update to `$likes = $pdo->prepare("DELETE FROM likes WHERE post_id like Concat( :like_p_id,'%')"); $likes->bindParam(':like_p_id', $p_id); $likes->execute();` you missed a `)` in the query so I will mark as right – Otávio Barreto Sep 12 '19 at 18:47

DELETE where post_id = PEzQo82KYTLLoXw AND `PEzQo82KYTLLoXw#comment_id` random

1 Answers1