title: MySQL comparing stored date with current date and execute
body: <p>I have stored dates (dd/mm/yyyy) in text format in a <code>table</code> in a field called <code>dates</code>. I want to compare those dates with the current date and if the dates are smaller (if the dates have passed) to move the entire row into a new table called <code>archive</code>. Tried something with the <code>DATEDIFF()</code> but I'm new to MySQL and can't figure it out.</p>