<?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.