Quick Pivot Table with Mysql

Hi,
a pivot table is easy to make on mysql:


replace into tablea
select tableb.col1
from tableb as tableb
where 1=1
;

But the secret for a good pivot table is that we can make business logic on the query:

1)   count(case when c like '%something%' then 1 end) as col2

2)  other aggregation functions can be used like avg, ...


best
tecbea