` IN (17, 48, 54, 64, 75, 13, 30, 37, 45, 55, 65, 76, 11,
33, 46, 58, 68, 80) AND count >= 3 GROUP BY `Plans`.`id`
but it selected only those with less that 3, what I am doing wrong ?
Thanks
--
Pupeno <[EMAIL PROTECTED]> (http://pupeno.com)
Reading ? Science Fiction ? http://sfreade
look at
> http://dev.mysql.com/doc/mysql/en/group-by-functions.html and read the part
> about GROUP_CONCAT()...
Outch! I'm running MySQL 4.0, I somehow knew that I was going to need a
feature of MySQL 4.1 (it seems mysql 4.0 and 4.1 added LOT'S of good
features, very nice indeed),
7;.
Currently I have a query that is able to return (doing a left join):
'A', 'B', 'E'
'A', 'B', 'F'
'C', 'D', NULL
But I need this:
'A', 'B', 'E,F'
'C', 'D', NULL
Can SQL
'joined' the 'Eric Clapton' group during that performance ? Or
for example, when Paul McCartney goes doing a tour as Paul McCartney, do the
musicians who go with them join the group Paul McCartney ?
Thanks.
- --
Pupeno: [EMAIL PROTECTED] - http://www.pupeno.com
Reading Science Fict
?
If in another table, how would you manage translations (that is, the system
is multilingual), having the translations in that table, or another table ?
or what ?
Thank you.
- --
Pupeno: [EMAIL PROTECTED] - http://www.pupeno.com
Reading Science Fiction ? http://sfreaders.com.ar
-BEGIN PGP
uot;, the main artists would be Queen, while a
lot of other people participated in the album, even as musicians (that is,
playing an instrument or doing something).
I'm still stuck with the problem that groups and artists are interchangable
things, how would you solve this ?
Thank you
n_id fields would be empty
and half the group_id fields would be empty. I was thinking about:
SONG-TO-PERSON-OR-GROUP LINK TABLE
* song_id
* musician_id
* type ('person', 'group')
* role (performer, lyricist, etc.)
But this is the solution that has so many redundant data. It's
list them, BUT, with some identification if it's a person or a group, so
in the listing I can do some exceptions.
Any comment is very well appretiated.
Thank you.
- --
Pupeno: [EMAIL PROTECTED] - http://www.pupeno.com
Reading Science Fiction ? http://sfreaders.com.ar
-BEGIN PGP SIGNATURE---
