mysql正則匹配解決查詢一個欄位是否在另一個欄位中

select b.filter_name , count(*) from at_goods a , at_search_filter b
where a.application REGEXP b.filter_name
group by b.filter_name