SharkD wrote:
> Something like that. Also, Google "SQL JOIN" if your data is spread 
> across multiple tables.

Err, no.  The point of my question was that I don't know it's ratings, 
publishers, etc.  All I know is that there are tags.

Think of (say) ID3 tags, or arbitrary user tags. I know how to store that in 
SQL. I want to know how to make arbitrary queries against the data. Or, 
rather, how best to represent arbitrary queries.

Or, in other words, what would you use to store

WHERE Publisher = "Warner Brothers"
AND Language IN("Arabic","French")
AND Rating != "R"
AND Media IN("DVD","VHS")

into relational tables rather than a stored procedure?

-- 
Darren New, San Diego CA, USA (PST)
    C# - a language whose greatest drawback
    is that it's best implementation comes
    from a company that doesn't hate Microsoft.

Post a reply to this message