Update rows with ids in CSV value passed to stored procedure

[samvb]

Hei all,

I am trying to update rows whose values is in a csv. i.e. 1,2,3

the stored proc looks like this:

spname(IN ids varchar(100)){
 
update tbl1 SET updaterow=1 WHERE rowid IN FIND_IN_SET(rowid,ids);
 
}
 

Only one row gets updated. Any memory-safe work around this?

[Rabbit]

Find in set returns the index of the occurrence of the first parameter in the second parameter. You don't check the rowid against it, you just need to check that the return value is greater than zero.

[samvb]

I understand. Any work around? Is the only way to send the ids one by one for an update?

[Rabbit]

You don't need a work around, you just need to use the function correctly. Like I said in my earlier post, check that the return value is greater than 0. There's no need for the IN operator nor the additional reference to rowid.