爆炸并检查是否存在

Question

this is MySQL table structure:

TABLE: products

|----------------------------------------------|
|   id    |             product_ids            |
|   1     |              51                    |
|   2     |              616,2,38              |
|   3     |              (NULL)                |
|   4     |              426,605,604           |
|----------------------------------------------|

What im looking is a way for the code to check if the id 605 exists in product_ids row, and if it does to replace for another ID:

any idea how can i accomplish this?

I was thinking of a sql QUERY...

Answer 1

To find out if it contains '605':

SELECT id, product_ids FROM products 
where product_ids REGEXP '^.*[^\d]605(?!\d).*$'

Comment: this is, by the way, a very good example why we shouldn't use multiple values in the same field!

Now once you have it - you can do whatever you want, you can play with it:

$new_product_ids = preg_replace('/^(.*[^\d])(605)(?!\d)(.*)$/','${1}new_id${3}',$row1['product_ids']);

and update the row:

update products set product_ids = '$new_product_ids' where id = $id