Welcome Guest, Not a member yet? Register   Sign In
Search Results
    Thread: How to remove the first word From Mysql Table?
Post: RE: How to remove the first word From Mysql Table?

nfaiz Wrote: (05-08-2021, 09:29 AM) -- Like this SQL? Code: -- UPDATE items SET Coupon_codes = SUBSTRING(Coupon_codes, LOCATE(' ', Coupon_codes)+1) --WHERE id = :id: -- -- Yes . But How Can ...
9,262 Views
10 Replies
05-08-2021, 10:26 AM
litecoin90
    Thread: How to remove the first word From Mysql Table?
Post: RE: How to remove the first word From Mysql Table?

wdeda Wrote: (05-08-2021, 07:11 AM) -- Below, assuming you are using CI 4, the query needed to perform the action: PHP Code: -- $db = $this->db; $id = '1'; $query = $db->table('items') ->selec...
9,262 Views
10 Replies
05-08-2021, 09:28 AM
litecoin90
    Thread: How to remove the first word From Mysql Table?
Post: RE: How to remove the first word From Mysql Table?

InsiteFX Wrote: (05-08-2021, 02:30 AM) -- Yoou also need to show the data array that your passing to it. -- Code: -- $data = $itemId->coupon_codes; -- coupon_codes Is Mysql Table which C...
9,262 Views
10 Replies
05-08-2021, 03:36 AM
litecoin90
    Thread: How to remove the first word From Mysql Table?
Post: RE: How to remove the first word From Mysql Table?

My controllers Code: Code: --                             $this->Item_model->updateItemcoupon($data, $id); -- My Modal Code: Code: -- public function updateItemcoupon($data, $id)...
9,262 Views
10 Replies
05-07-2021, 06:40 PM
litecoin90
    Thread: How to remove the first word From Mysql Table?
Post: How to remove the first word From Mysql Table?

Hello all codeigniters, For example A table ('Items') have a column "Coupon_codes". which contains values - Code: -- Start JkLkLKLLk65 Flashsale2021 -- I want to delete Start and make it. Code:...
9,262 Views
10 Replies
05-07-2021, 06:39 AM
litecoin90

Theme © iAndrew 2016 - Forum software by © MyBB