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 criteria.
A simple query:
select
userID, attrType, attrValue from properties
where
propType = 1
and
propValue= 'some value'
The problem I'm running into is that the number of attributes could be over
50.
Would a query with many sets of
(propType = 1 and propValue= 'some value')
or
(propType = 2 and propValue= 'some other value')
or ...
work better than doing the same thing with unions?
Or does anyone have an alternate solution?
Thanks for any help!
-- Avi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
