On 6/24/2010 2:00 PM, Darren New wrote:
> Basically, I have a bunch of entries in a database. Call em movies. Each
> is tagged with a collection of arbitrary tags: release date, studio,
> genre, etc. There's no specific collection of tags, but each tag is
> either present or absent, with no other associated value.
>
> Now I want to represent groups of movies. I want to be able to say, for
> example, movies that are from Warner Brothers, and that have arabic *or*
> french subtitles, but aren't rated R, that are out on DVD or out on VHS,
> ...
>
> So, basically, I want to be able to express a fairly general boolean
> equation on an arbitrary collection of variables and store it as a SQL
> table.
>
> However, I haven't been able to figure out the google terms that might
> actually give me something other than a tutorial for using the boolean
> type in SQL.
>


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


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


-- 
http://isometricland.com

Post a reply to this message