NOT LIKE in an SQL query

Question

Why does this simple query return  ORA-00936  missing expression   the database is Oracle as you can tell    SELECT   FROM transactions WHERE id NOT LIKE  1   AND NOT LIKE  2     I feel silly  but what am I doing wrong

User · Answer

You ve missed the id out before the NOT  it needs to be specified   SELECT   FROM transactions WHERE id NOT LIKE  1   AND id NOT LIKE  2

User · Answer

After  quot AND quot  and after  quot OR quot  the QUERY has forgotten what it is all about  I would also not know that it is about in any SQL   programming language  if SOMETHING equals  quot X quot  or SOMETHING equals  quot Y quot   COLUMN NOT LIKE  quot A  quot  AND COLUMN NOT LIKE  quot B  quot

User · Answer

You have missed out the field name id in the second NOT LIKE  Try   SELECT   FROM transactions WHERE id NOT LIKE  1   AND id NOT LIKE  2     The AND in the where clause joins 2 full condition expressions such as id NOT LIKE  1   and can t be used to list multiple values that the id is  not like

User · Answer

You need to specify the column in both expressions   SELECT   FROM transactions WHERE id NOT LIKE  1   AND id NOT LIKE  2

[sql] 'NOT LIKE' in an SQL query

Examples related to sql

Examples related to oracle

Examples related to ora-00936