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:

JkLkLKLLk65
Flashsale2021

is that possible to do this using mysql query? How can i do that?

@litecoin90,

Yes it is possible to do that. Please show us your current SQL statement.

My controllers Code:

Code:

                            $this->Item_model->updateItemcoupon($data, $id);

My Modal Code:

Code:

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

Yoou also need to show the data array that your passing to it.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

Yoou also need to show the data array that your passing to it.

Code:

                $data = $itemId->coupon_codes;

coupon_codes Is Mysql Table which Containt Text Like This   Start JkLkLKLLk65 Flashsale2021  
Now i Want to Remove The First word Start From coupon_codes Table .. From Tell me How Can i do This Action??

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')
->select('Coupon_codes')
->where('id', $id)
->delete(); 


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')
->select('Coupon_codes')
->where('id', $id)
->delete(); 


Hi, Can You tell me How to remove the first word From Mysql Table?
I Want To Update My Mysql Table and Want to remove The first word From My Mysql Table.. Table Contact Text ...

Like this SQL?

Code:

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

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 ??

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')
->select('Coupon_codes')
->where('id', $id)
->delete(); 


Hi, Can You tell me How to remove the first word From Mysql Table?
I Want To Update My Mysql Table and Want to remove The first word From My Mysql Table.. Table Contact Text ...

In the same way used in the example for the "items" table.

PHP Code:

$query = $db->table('items') // in this line the table is informed, in this example, items;
->select('Coupon_codes') // here the row where the text to be deleted is located, in this example, Coupon_codes.