我想按两个库仑结果分组，类似的条件在哪里满足

Question

SELECT * 
FROM ks_fund_transaction 
where  (from_fund  like '%COIN%' or to_fund  like '%COIN%')  
GROUP BY from_fund;

在这里你可以看到结果http://prntscr.com/1ze745i

id  fund_type   from_fund   to_fund amount  t_date  dt  update_date emp_id
55  Withdrawal  COIN SWITCH KUBER   KJSB    100 2021-11-13  2021-11-13  2021-11-13  415
54  Deposite    KJSB    COIN SWITCH KUBER   10000   2021-11-13  2021-11-13  2021-11-13  415
56  Withdrawal  KJSB1   COIN SWITCH KUBER   100 2021-11-13  2021-11-13  2021-11-13  415

只有一次硬币开关库伯会得到

Answer 1

在GROUP BY中使用条件

GROUP BY IF(from_fund LIKE '%COIN%', from_fund, to_fund)