Posted by Frankly on 06/24/06 17:56

"J.O. Aho" <user@example.net> wrote in message
news:4fp1npF1je48bU1@individual.net...
> I'm really not sure, I do like the idea of the binary way, but having
> different columns is the easy way around, of course you need to add more
> columns if you increase the number of places where to post. With the
> columns it's easier to search for sites that has been posted at one
> specific site
>
> SELECT * FROM table WHERE site1column=1;
>
> while withe the binary system you would need to make
>
> SELECT * FROM table where stiescolumn IN(1,3,5,7,9,11,13,15);


Another choice is Set. Set is like Enum with the difference it allows you
to have more than 1 choice.
At this point I am thinking 1 feild per site would be better for us. it
really all comes down to what is easiest for my wife. Back to my learning..
TTYS

Frank

[Back to original message]