Hi there:
I'd like to know if there is a method using MySQL 3.22.xx, of placing multiple data elements in a single field, and being able to do a select on this data?
I don't mean use an ENUM() field as this is either 'A' OR 'B' etc. If anything I need 'A' AND 'B'.
For example:
I'd like to have a subscriber able to subscribe to multiple categories. But I'm not sure how to design the table/s to be able to perform a select for an email address to map to multiple categories.
Can anyone help me out??
Cheers.
Russ
I'd like to know if there is a method using MySQL 3.22.xx, of placing multiple data elements in a single field, and being able to do a select on this data?
I don't mean use an ENUM() field as this is either 'A' OR 'B' etc. If anything I need 'A' AND 'B'.
For example:
I'd like to have a subscriber able to subscribe to multiple categories. But I'm not sure how to design the table/s to be able to perform a select for an email address to map to multiple categories.
Can anyone help me out??
Cheers.
Russ