[eluser]Unknown[/eluser]
Hi everyone,
Here is a mysql query i have in my application:
Code:
UPDATE items SET item_name = REPLACE(item_name, 'ipod', 'iPod') WHERE item_name LIKE 'ipod%'
Note: This is not the exact sql query i am running. I have changed fields names and data for this example.
Is there a way for me to run this query with active record class. Something like:
Code:
$this->db->like('item_name', 'ipod', 'after');
$this->db->update('items', array('item_name' => "REPLACE(item_name, 'ipod', 'iPod')");
thanks...