Sinisa Milivojevic wrote:
>
> No, but in 4.1 there will be INTERCEPT and MINUS too, beside
> UNION's (with or without ALL option). Those three combined can
> produce any of the above relational operations.
wooah! *dribble*! :-)
When can I start using this code?
Where can I get it from?
ch
Jeremy Zawodny writes:
> On Thu, Dec 06, 2001 at 11:59:04AM +, Chris Withers wrote:
> > Can UNION do boolean AND, NOT and OR combination of sets generated
> > by SELECTs?
>
> Hmm...
>
> http://www.mysql.com/doc/U/N/UNION.html
>
> Nope. :-(
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PR
On Thu, Dec 06, 2001 at 11:59:04AM +, Chris Withers wrote:
> Jeremy Zawodny wrote:
> >
> > > Yup, but given that each WHERE clause is already pretty hairy, I was
> > > hoping someone would say "oh, sure, here's some set operations to
> > > complement UNION" ;-)
> >
> > How about, "try out My
Jeremy Zawodny wrote:
>
> > Yup, but given that each WHERE clause is already pretty hairy, I was
> > hoping someone would say "oh, sure, here's some set operations to
> > complement UNION" ;-)
>
> How about, "try out MySQL 4.0 with UNION support"? :-)
Can UNION do boolean AND, NOT and OR combin
On Thu, Dec 06, 2001 at 11:15:03AM +, Chris Withers wrote:
> Jeremy Zawodny wrote:
> >
> > Hm. It sounds like you just want to combine the WHERE clauses
> > (intelligently) and end up with one big query, right?
>
> Yup, but given that each WHERE clause is already pretty hairy, I was
> hopin
Jeremy Zawodny wrote:
>
> Hm. It sounds like you just want to combine the WHERE clauses
> (intelligently) and end up with one big query, right?
Yup, but given that each WHERE clause is already pretty hairy, I was hoping
someone would say "oh, sure, here's some set operations to complement UNION
On Thu, Dec 06, 2001 at 09:10:38AM +, Chris Withers wrote:
> ...in MySQL, to keep the list filter happy :-(
>
> Hi,
>
> I have several different SELECTs, each of which returns a set of
> results which I'd like to combine in a boolean fashion. So, say I
> have 4 selects, w, x, y, and
...in MySQL, to keep the list filter happy :-(
Hi,
I have several different SELECTs, each of which returns a set of results which
I'd like to combine in a boolean fashion.
So, say I have 4 selects, w, x, y, and z, I might want to do:
((x AND y) OR Z ) AND (NOT w)
What's the best way of going
