On Sat, 06 Nov 2004 20:34:47 -0800, L a n a <[EMAIL PROTECTED]> wrote:
> However, NOT operator gives an error:
> 3. SELECT data_id from table WHERE keyword = a NOT keyword =b ( returns sql
> error)
AND NOT as well as OR NOT should work, I think. How do you think MySQL
would be able to distinguish
Saturday, November 06, 2004 10:35 PM
> To: [EMAIL PROTECTED]
> Subject: mysql NOT operator
>
> Hello,
>
> Could you please tell me how I can write an sql statement in php when I'd
> llike to select boolean search in one field like "except" or "NOT&quo
a n a" <[EMAIL PROTECTED]>
Subject: mysql NOT operator
Message-ID: <[EMAIL PROTECTED]>
Hello,
Could you please tell me how I can write an sql statement in php when I'd
llike to select boolean search in one field like "except" or "NOT" result.
What I mean
Hello,
Could you please tell me how I can write an sql statement in php when I'd
llike to select boolean search in one field like "except" or "NOT" result.
What I mean here is that I can execute the following:
1. SELECT data_id from table WHERE keyword = a AND keyword =b
2. SELECT data_id from ta
