php - 使用Mysql中的where和Like子句过滤数据

我在mysql数据库中使用LIKE关键字过滤数据。这是以下查询：

Select c.c_id, c.c_name, slab,
COUNT(c.c_id) as tot_visit,
SUM(t.bill) as tot_revenue, c.priority, c.ratings
From tbl_customer c
inner join tbl_transaction t on c.c_id=t.c_id
group by c.c_id
Where r_id="r1" AND c.slab LIKE "%teen%"

当我删除此-> AND c.occupation LIKE“％teen％”
我正在尝试但并未克服。任何帮助，将不胜感激。

编辑
我按青少年，年轻人和老年人的年龄筛选数据。相同的代码在其他php文件中工作正常，但在此情况下却不行。

if(isset($_GET['submit']))
{
    if (isset($_GET["teen"]))
    {
        $arguments[] = "c.slab LIKE '%teen%'";
    }
    if (isset($_GET["young"])) {
        $arguments[] = "c.slab LIKE '%young%'";
    }
    if (isset($_GET["senior"]))
    {
        $arguments[] = "c.slab LIKE '%senior%'";
    }

    if(!empty($arguments)) {
      $str = implode(' or ',$arguments);
      $qry = mysql_query('Select c.c_id, c.c_name, c.slab,
COUNT(c.c_id) as tot_visit,
SUM(t.bill) as tot_revenue, c.priority, c.ratings
From tbl_customer c
inner join tbl_transaction t on c.c_id=t.c_id
Where r_id="r1" AND "'.$str.'"
group by c.c_id');

没有得到所有这一切的错。请帮助。

最佳答案

尝试在where之前写groupby条件

Select c.c_id, c.c_name, slab,
COUNT(c.c_id) as tot_visit,
SUM(t.bill) as tot_revenue, c.priority, c.ratings
From tbl_customer c
inner join tbl_transaction t on c.c_id=t.c_id
Where r_id="r1" AND c.occupation LIKE "%teen%"
group by c.c_id

关于php - 使用Mysql中的where和Like子句过滤数据，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/22759842/