Trigger - If time between? I wish to use a mysql trigger that will update a column called peak to 0 or 1 based on if the CURTIME() is between 08:01 &amp; 11:59.

Can anyone help with this trigger?
You need something like that:

BEGIN
  IF CURTIME() BETWEEN '08:00:00' AND '11:59:59'
    THEN UPDATE ...
  END IF
END


This trigger will be activated each time the event occure but it will do something only if current time is within the given range and will do nothing otherwise.