Each member can have several interests, and each interest can be held by
several members. The best way to do this is with a third table relating the
two:
CREATE TABLE member_interests
(member_id INT, interest_id INT,
UNIQUE INDEX mem_int_idx (member_id,interest_id);
Each row in this
Create a seperate table called member_interests or something similar
Store one member_id and one interest_id (or whatever you have your PKs
named) in each row.
This is similar to an order entry system, which typically has one
table for order_headers and one for order_detail. The order_header
tab