Re: Perl/SQL query - grouping 'one to many' records

Just use SQL group by function.

Few examples from MySQL website

Comment on Re: Perl/SQL query - grouping 'one to many' records

Replies are listed 'Best First'.
Re^2: Perl/SQL query - grouping 'one to many' records by pcdj_d (Initiate) on Dec 09, 2008 at 23:36 UTC
I was under the impression you couldn't 'group by' text fields? Which all these fields are (the figures '1,2,3' etc were just an example - they are all numeric IDs prefixed with some text.)	[reply]
Re^3: Perl/SQL query - grouping 'one to many' records by jasonk (Parson) on Dec 10, 2008 at 02:04 UTC
Your impression is wrong, you can group by any field you want. www.jasonkohles.com We're not surrounded, we're in a target-rich environment!	[reply]