FuelPHP Forums

zzal

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;');

Thanks!

zzal

Got it!

$connection = \Database_PDO_Connection::instance();

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