Remove values in comma separated list from database on CodeIgniter

Question

Edit :

I give another example,

products_table

| ID | product_name | images |
|---------------------------------------|
| 1 | Phone | img1.jpg,img2.jpg
| 2 | Canon | img1.jpg,img2.jpg,img3.jpg
| 3 | Cocac | img1.jpg,img2.jpg,img3.jpg,img4.jpg
| 4 | Lamps | img1.jpg,img2.jpg,img3.jpg,img4.jpg

Lats say I remove image "img3.jpg" from Lamps product without remove other images. What is the SQL call to this?

Possible duplicate of [The best way to remove value from SET field?](https://stackoverflow.com/questions/14642658/the-best-way-to-remove-value-from-set-field) — , May 25 '17 at 06:46

Md. Nashir Uddin · Accepted Answer · 2017-05-28T08:29:11.540

2

$this->db->query("UPDATE products_table SET images=replace(images, 'img3.jpg,',''),images=replace(images, ',img3.jpg','') WHERE product_name='Lamps'");

edited May 28 '17 at 08:29

answered May 25 '17 at 07:16

Md. Nashir Uddin

730
7
20

code you given is working for delete but the last images can't delete. – MSufian May 26 '17 at 15:47
@Googlemy I have updated my code. Hope now this code delete the last image. Thanks. – Md. Nashir Uddin May 27 '17 at 07:43

Remove values in comma separated list from database on CodeIgniter

1 Answers1