On 10 Jul 2015, at 5:58pm, James K. Lowden <jklowden at schemamania.org> wrote:
> Simon Slavin <slavins at bigfraud.org> wrote: > >> If you're going to do it properly you have a keywords column which >> contains strings like >> >> , >> ,animal, >> ,animal,predator, >> ,animal,predator,bird, > > Why do it that way? I would recommend a schema like Keith's, with one > keyword per row in a separate table. I was trying not to change the ideas of the OP too much by introducing another table. Keith's suggestion of normalization is, of course, a superior solution if the schema can be changed that much. Simon.
