[
I have 2 tables. Table A containing 2 fields. A user ID and a picture ID =
A(uid,pid) and another table B, containing 3 fields. The picture ID, an
attribute ID and a value for that attribute = B(pid,aid,value).
Table B contains several rows for a single PID with various AIDs and values.
On Wed, 2010-06-16 at 08:59 +0100, Nigel Wood wrote:
I'd use:
drop temporary table if exists AttSearchMatches;
select pid as targetPid, count(*) as criteraMatched from B where
userId=35 and ( (b.aid=1 and b.value 50) OR (b.aid=3 and b.value
=4) ) group by pid having criteraMatched = 2;
drop
Hi!
Daniel Brown wrote:
[Top-post.]
You'll probably have much better luck on the MySQL General list.
CC'ed on this email.
On Tue, Jun 15, 2010 at 20:58, Jan Reiter the-fal...@gmx.net wrote:
Hi folks!
[[...]]
I have 2 tables. Table A containing 2 fields. A user ID and a
[Top-post.]
You'll probably have much better luck on the MySQL General list.
CC'ed on this email.
On Tue, Jun 15, 2010 at 20:58, Jan Reiter the-fal...@gmx.net wrote:
Hi folks!
I'm kind of ashamed to ask a question, as I haven't followed this list very
much lately.
This isn't