title: how to create trigger after update if the given date is equal to the current date
body: <p>This is the table i had created</p>
  
  <pre><code>CREATE TABLE dob (name VARCHAR(20),date VARCHAR(100));
  </code></pre>
  
  <p>This is the data i had loaded in to the table dob</p>
  
  <pre><code>uttej,2017-08-22
  venki,1997-07-15
  porna,1995-05-11
  pp,1997-07-07
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/Ge4aq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ge4aq.png" alt="enter image description here"></a></p>
  
  <p>This is the query i had written but there is an error </p>
  
  <p>delimiter |</p>
  
  <pre><code>CREATE TRIGGER test after update on dob
  for each row
  begin
  update dob where date = SELECT NOW();
  end;
  </code></pre>
  
  <p>|</p>
  
  <p><a href="https://i.stack.imgur.com/kPcQU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kPcQU.png" alt="enter image description here"></a>
  need some help ???????</p>