title: MySQL - Change table value when current time reaches midnight
body: <p>We want to change a value in our table when the current time reaches midnight (23:59:59) in our case, but we are unsure on how to approach this. The table has a "startTime" and "endTime" and we want to set the "endTime" to "23:59:59" when the current time reaches midnight, if there is a value in "startTime" in the same row. Can we use stored procedures or triggers to fulfill this requirement? Or is this the wrong way to approach this? </p>
  
  <p>New rows are constantly being added to the table, so it should listen for the change in time continually, or in intervals of once every day.</p>