How to remove the first word From Mysql Table?

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