Subject: how to select with a set type field
I have a table 'organisms' with a field 'category'
of type SET('birds','bees','flowers','trees').
A record could have none or more of these in that field.
How do I select all records with both 'flowers' and 'trees'?
I can "SELECT category,key FROM organisms;"
Then I can test for the strings 'flowers' && 'trees' in the result set
and then do another select for those id's but that's obviously the slow way.
jonathan soons
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
