title: MySQL Where date is greater than one month?
body: <p>I have a datetime column called 'last_login'.</p>
  
  <p>I want to query my database to select all records that haven't logged in within the last month. How do I do this?</p>
  
  <p>This is what I have currently:</p>
  
  <pre><code>$query = $this-&gt;query("SELECT u.id, u.name, u.email, u.registered, g.name as group_name FROM `:@users` AS u LEFT JOIN `:@groups` AS g on u.group_id = g.id WHERE u.last_login = ...... LIMIT {$limit_start}, {$limit_end}");
  </code></pre>
  
  <p>:@ = database prefix </p>