title: sql error creating trigger in sqlite
body: <p>I am using <code>sqlite 2.8.17</code> installed on <code>ubuntu lucid</code>  ( I used <code>apt-get install sqlite</code>)</p>
  
  <p>I have a <code>college</code> table on which I tried to create a trigger(as mentioned in dbclass.org video)</p>
  
  <pre><code>create trigger R4
  before insert on College
  for each row
  when exists (select * from College where cName = New.cName)
  begin
    select raise(ignore);
  end;
  </code></pre>
  
  <p>This causes an error</p>
  
  <pre><code>SQL error: near "select": syntax error
  </code></pre>
  
  <p>the schema for college  is</p>
  
  <pre><code>create table College(cName text, state text, enrollment int);
  </code></pre>