CodeIgniter Forums
How to remove the first word From Mysql Table? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Best Practices (https://forum.codeigniter.com/forumdisplay.php?fid=12)
+--- Thread: How to remove the first word From Mysql Table? (/showthread.php?tid=79189)

Pages: 1 2


RE: How to remove the first word From Mysql Table? - nfaiz - 05-09-2021

(05-08-2021, 10:26 AM)litecoin90 Wrote:
(05-08-2021, 09:29 AM)nfaiz Wrote: Like this SQL?

Code:
UPDATE items SET
Coupon_codes = SUBSTRING(Coupon_codes, LOCATE(' ', Coupon_codes)+1)
--WHERE id = :id:

Yes . But How Can i do This in codeigniter?


Here is My code 


Code:
public function updateItemcoupon($data, $id)
    {
        $this->db->where('Items', $id);
        $this->db->update('Coupon_codes', $data);
        return TRUE;
    }


What should i add ??

https://www.codeigniter.com/user_guide/database/query_builder.html?highlight=update#updating-data

$builder->set()
set the third parameter to false?