Code :
โค้ด: เลือกทั้งหมด
if($this->getState('filter.search')!==''&& $this->getState('filter.search')!==null){
$search = $db->quote('%'. str_replace('', '%', $db->escape(trim($this->getState('filter.search')),true).'%'));
$query->where($db->qn('c.name').'LIKE'.$search);
}