update replace

gruu · #1 (**permalink**) 08-18-2008, 08:49 AM

I need to do a query like this:

UPDATE my_table set text = REPLACE(text,'oldtext','newtext') where text REGEXP 'oldtext'

But dunno how to do that using Zend_Db_Table->update

Anyone knows?
Thx.

Tekerson · #2 (**permalink**) 08-18-2008, 11:09 AM

How about:

Code:

$bind = array(
  'text' => new Zend_Db_Expr("REPLACE(text, 'oldtext', 'newtext')")
);
$db->update('my_table', $bind, "text REGEXP 'oldtext'");

If you have something that doesn't need escaping (eg. an expression) you can generally wrap it in a Zend_Db_Expr object.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode