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 table WHERE keyword = a OR keyword =b
However, NOT operator gives an error:
3. SELECT data_id from table WHERE keyword = a NOT keyword =b ( returns sql error)
Could you please help? Thank you, Lana
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
