The comma after Gerlad R was a typo.
As for the 500 actors issue, I'm merely using the movie db as an example.
People always post the strangest db's to this list ("I have one table for
monkeys and one for fishes who speak Urdu, and I need..."), so I thought I'd
spare everyone the particulars of mine.
I'm quite eager to use some of the 4.0/4.1 features, but for now, I have to
play in the 3.23 sandbox.
Ultimately, I'd like single rows here, but will use PHP to compact the rows
for now.
Thanks for your help everyone!
Patrick
> I can't say I like the idea of concatenating all those items into one.
> Look at the parsing difficulty you've gotten yourself into. Is "Molen"
> a director? Or is it "Gerald R"?
> Most databases don't have any functions for this grouping-concatenation,
> since it leaves you with a result set that has a field of arbitrary
> length. What about a movie with 500 actors?
> So, really, I prefer to order by the movie, then the director. While
> processing the result set, just be aware you might have duplicate
> consecutive movies. Then you can roll in the directors as you go.
>
> So much for that lecture. If you're willing to use the ALPHA mySQL 4.1,
> there is a method that promises to do what you want:
> http://www.mysql.com/doc/en/GROUP-BY-Functions.html, look at
> GROUP_CONCAT. I think that fits the bill, with the caveat that it might
> well not be ready for prime-time yet. Oh, and it won't work on (any)
> other databases.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
