MySQL & crosstabs.

[basildon]

Hi

I'm using Perl DBI and MySQL and want to do some fairly extensive counts.

Can I crosstab using an SQL query to MySQL or do I need to use PERL to do this?

Any help appreciated.

Thanks

 

[Broccoli2]

There's a FAQ on the MySQL site to explain how to do this neatly - it's at

http://mysql.com/articles/wizard/index.html

-Rob