Hi
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
> Yes. I know that group_id can't be both 1 and 3 at the same time. This
is
> exactly my problem. How to find a record that belongs to both groups 1
> AND 3? If I use OR here, I get also records that only belong to group 1
> or
* Jouni Hartikainen
> Hi
* someone else
> >A group_id cannot be both 1 AND 3, but it can be 1 OR 3.
> >Try OR
* Jouni Hartikainen
> Yes. I know that group_id can't be both 1 and 3 at the same time. This is
> exactly my problem. How to find a record that belongs to both groups 1
> AND 3? If I use
Hi
A group_id cannot be both 1 AND 3, but it can be 1 OR 3.
Try OR
Yes. I know that group_id can't be both 1 and 3 at the same time. This is
exactly
my problem. How to find a record that belongs to both groups 1 AND 3?
If I use OR here, I get also records that only belong to group 1 or only
belo
A group_id cannot be both 1 AND 3, but it can be 1 OR 3.
Try OR
Jouni Hartikainen wrote:
Hi.
> how about:
>
> select record.*
> from link
> where group_id='x'
> left join record on record.archive_id=link.archive_id
> ?
The problem with this query is that with simple left join, I can
search on
Hi.
> how about:
>
> select record.*
> from link
> where group_id='x'
> left join record on record.archive_id=link.archive_id
> ?
The problem with this query is that with simple left join, I can search only
by a single group.
If I set x to 3 here, I get all records that belong to group 3. But wha
- Original Message -
From: "Pakó Géza" <[EMAIL PROTECTED]>
To: "Jouni Hartikainen" <[EMAIL PROTECTED]>
Sent: Saturday, October 11, 2003 7:03 PM
Subject: Re: How to search by groups efficiently with MySql 4.0.15?
> how about:
>
> select record.
Hi all.
I have this kind of problem setup:
1. I have a bunch of records and I need to store some record specific data
about each of them (date, owner etc).
2. I have a list of categories (=groups) in which a record may belong to and
I have to be able to store some group specific data (name, co