EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 26, 2005 4:25 PM
> To: mysql@lists.mysql.com
> Subject: Union vs OR
>
> I have a table that holds attributes for users. This is the structure:
>
> TABLE properties (
> id int(11) NOT NULL,
> userid int
It's getting late on Friday, but couldn't you build a table with all of
the parameter combinations and then just join against that table?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 4:25 PM
To: mysql@lists.mysql.com
Subject
I have a table that holds attributes for users. This is the structure:
TABLE properties (
id int(11) NOT NULL,
userid int(11) NOT NULL,
attrType int(11) NOT NULL,
attrValue text NOT NULL,
FULLTEXT KEY propValue (propValue)
) TYPE=MyISAM;
The table is used to find people based on criteri