On 12/15/06, jason schleifer <[EMAIL PROTECTED]> wrote:
If the user specifies one or more tags, I want to be able to return all
moves that match EITHER tag.. for example, if htey specify "carrey" and
"snow", it should return all movies that have either carrey or snow in the
list.
maybe this mig
Hi Jason.
Can make is easier so:
SELECT * FROM film WHERE
genre IN ("comedy", "drama")
AND tag IN ("bill murry", "scarlett o'hara"
,"silly");
--- jason schleifer <[EMAIL PROTECTED]> wrote:
> heya folks,
>
> I'm trying to figure out the proper syntax for doing
> a query of something
> like this
two tings I would do.
1. further normalize your tag field make it a table keyed by id and tag
join to this in your query
2. for genre = "comedy" OR genre = "drama" I would genre IN ("comedy",
"drama")
you might consider further normalizing genre, to reduce duplication and
also allow multi
heya folks,
I'm trying to figure out the proper syntax for doing a query of something
like this:
I have two different types of things that people will be querying for, and I
want to do an OR on each, but and AND between them..
So let's say i've got a table that looks like this:
Create TABLE fi
4 matches
Mail list logo
