title: How to do NOT in LIKE query in SQLite?
body: <p>I have a table as follows:</p>
  
  <pre>
  CREATE TABLE Foo(
      id      INT PRIMARY KEY,
      key     VARCHAR,
      value   VARCHAR
  )
  
  id       key     value
  1        Hi      ABCDE/FGHI
  2        Hi      DFGRT
  3        Hi      FSEHU/
  </pre>
  
  <p>Pre-existing library function (edited for clarity):</p>
  
  <pre>
  char* Foo_getId(char *value){
      char *query = "SELECT id FROM Foo WHERE value LIKE ?";
      sqlite3_stmt *statement;
      int rc = sqlite3_prepare_v2(connection, query, strlen(query), &statement, NULL);
      rc = sqlite3_bind_text(statement, 1, value, strlen(value), SQLITE_STATIC);
      rc = sqlite3_step(statement);
      return strdup((char*)sqlite3_column_text(statement, 0));
  }</pre>
  
  <p>My function:<pre>
  char *getFooIdFromValueWithoutSlash(){
      return Foo_getId("WHAT GOES HERE???");
  }</pre>
  How do create a LIKE query such that it will match any value which does not contain a '/'?</p>
  
  <p>E.g. <code>SELECT * FROM Foo WHERE value LIKE '%!/%'</code></p>
  
  <p>Note: the reason I am trying to do this is that I am interfacing with someone elses code of which I can only pass the value placed after the like.</p>