MYSQL TRIGGER: select columns of the row where i have the updated value
<p>I have a problem with this trigger. I want to select two columns values of the row i've just updated only if the column 'confirm' is updated with the '1' value.</p>

<pre><code>DELIMITER $$

CREATE TRIGGER `order_confirm` BEFORE UPDATE ON `order`
FOR EACH ROW 
BEGIN

  DECLARE c_id_order INT; DECLARE order_date DATE;

  IF(NEW.confirm&lt;&gt;OLD.confirm) THEN

     SELECT id_order, order.date INTO c_id_order, order_date FROM order  
     WHERE NEW.confirm = 1;

     CALL function_name(c_id_order, order_date);

   END IF;  

 END $$
DELIMITER ;
</code></pre>

<p>this is the error message:Result consisted of more than one row. 
Thank you a lot.</p>