สอบถามการค้นหาข้อมูลด้วย ้php mysql แบบหลายเงื่อนไข นอกจากใช้ if แล้วยังมีวิธีอื่นอีกไหมครับ

$sql="select s.ID_cate,s.subcate_ID,s.sub_name,p.pro_ID,p.pro_name,p.pro_image,p.pro_url,p.pro_merchants,p.pro_date,p.pro_click from tbl_subcate s inner join tbl_product p on p.subcate_ID=s.subcate_ID";
                        
                        if ($pro_name != '' and $date != '') {
                        	$sql.=" where p.pro_date='$date' and p.pro_name like '%" . trim($pro_name) . "%'";
                        } elseif ($pro_name != '' and $date == '') {
                        	$sql.=" where p.pro_name like '%" . trim($pro_name) . "%'";
                        } elseif ($pro_name == '' and $date != '') {
                        	$sql.=" where p.pro_date='$date'";
                        }

$sql="
select 
   s.ID_cate, s.subcate_ID, s.sub_name,
   p.pro_ID, p.pro_name, p.pro_image, p.pro_url, p.pro_merchants, p.pro_date, p.pro_click 
from tbl_subcate s inner join tbl_product p on p.subcate_ID=s.subcate_ID
where 1 ".
($pro_name?  " and p.pro_name like '%" . trim($pro_name) . "%' " : '').
($date? " and p.pro_date='$date' " : '');