Love Fuel?    Donate

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.
DB::update set value from another column?
  • Hi there!

    Can't find in the docs how can I produce this kind if query with DB::update() :
    UPDATE table SET col2 = col1;

    I was looking for some DB::raw() in the docs but didn't find any (Maybe I hung too long with another framework… ;)

    Or if I get the DB connection, can I do something like this? 

    $connection = Database_Connection::instance();
    $connection->exec('UPDATE table SET col2 = col1;');


  • Got it! 

    $connection = \Database_PDO_Connection::instance(); 
    $connection->query(\DB::UPDATE, 'UPDATE table SET col2 = col1;', false);

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion