<?php
       
            $post = $db->query("SELECT * FROM post");
            foreach($post as $rows){
                $explode = explode(",",$rows["post_category"]);
               
                if($have = in_array($get,$explode)){
                    $NewSql = $db->prepare("SELECT * FROM post WHERE post_category LIKE ?");
                    $NewSql->execute(array("%".$get."%"));
                    $NewRow = $NewSql->fetch();
                   
                    echo $NewRow["post_name"];
                }
            }
       
        ?>
Misal bu şekilde geleni aratıp bulabilirsiniz.