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 what you mean with "NOT" instead? Greetz Fred -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]