title: How to use MySQL built-in functions in Laravel DB::raw()
body: <p>I am using an sql query like the following with the MySQL built in ADDDATE() function in Laravel Query Builder to increment the date by 1 day. </p>
  
  <pre><code>$sql = "UPDATE my_table
          SET date_col = ADDDATE(date_col, INTERVAL 1 DAY)
          WHERE id = {$the_id}";
  
  DB::update($sql);
  </code></pre>
  
  <p>This is working fine and there is no reason to really change it.  However, I first tried to use Query Builder with DB::raw as follows.</p>
  
  <pre><code>DB::table('my_table')
     -&gt;where('id',$the_id)
     -&gt;update(['date_col'=&gt; DB::raw(ADDDATE(date_col, INTERVAL 1 DAY)]);
  </code></pre>
  
  <p>Is it possible to use the MySQL functions in this way?  Is my syntax wrong or what?</p>