I think your confusion stems from the fact that
a AND b NOT c
is not a valid boolean expression. You probably
mean to say
a AND b AND NOT c
Lezz Giles
----- Original Message -----
From: "Libor Matyáš" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 15, 2001 5:25 AM
Subject: how to solve NOT problem?
> hi,
> i'm having the following problem that sort of makes my life miserable :-)
>
> i've been working on a search script that could take a query like this:
> (car and bus) or apple not (orange and table)....etc.
> ...basicly any logical statement...and return the right references based
on
> searching specified fields in the database.
>
> the script so far basicaly breaks down the query and searches specified
> fields for words in the query. the result of this search is then stored in
a
> temporary table where the most important field is always a field f
> consisting of all the words from the query that were found in a particular
> row of fields in the main database.
>
> so the result could look like this:
> ref_id a b......f
> 1 1 0......car bus orange
> 2 0 0......car bus
> 3 1 1......car apple table
> 4 0 1......apple
>
> now, i need to convert the input query into a sql query that could be used
> with mysql. it all works fine if there are no "NOT" logical operators.
>
> for example:
> (car and bus) or apple
> would convert to
>
> SELECT * FROM T WHERE (((f LIKE "%car%") AND (f LIKE "%bus%")) OR (f LIKE
> "%apple%"))
>
> and returns the right results
>
> but when i use NOT.... i can't beleive that one cannot use NOT but has to
> use something like "f NOT LIKE...." instead which so much complicates the
> whole thing.
>
> does anybody have a short solution to this, before i start working on a
> converting mechanism?
>
> remember, that i strive for as simple script possible...so i'm looking for
a
> way of simply going from
>
> a AND b NOT c
>
> to
>
> f like a AND f like b NOT f like c
>
> ...or something in that sence.
>
> thanks a lot for your help.
>
> libor matyas
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
