title: MYSQL trigger to select * from table and check each value and update other table
body: <p>i am having where one of my table has a trigger which will execute after update of the table to check if the values of the fields for the id values updated, are true if any of value is false update other table with false else with true.</p>
  
  <pre><code>DELIMITER $$
  CREATE
  TRIGGER users_lookups
  AFTER UPDATE ON UsersValidations
  FOR EACH ROW
  BEGIN
  SELECT * FROM UsersValidations where id=New.id;
  /* MY SCENARIO 
  {   HOW to do this portion
  
    if(UsersValidations.value1 =="true" and UsersValidations.value2=="true" and UsersValidations.value3=="true")
      {
           update table2 set myvalue="true" where id=New.id;
      }
      else
      {
           update table2 set myvalue="false" where id=New.id;
      }
  
  }*/
  
  END$$
  </code></pre>