changing serialized items in database

[tito]

I've just imported 1000 ++ items from my old forums and I forgot to set the customfield to the new one.

All customfields have

a:1:{i:2;s:4:"1842";}

How can I do a query to update the column, I just want to change i:2 into i:11 where eventid >='350'

Thanks.

[NogDog]

Something like this?...

UPDATE `table_name` SET `col` = REPLACE(`col`, '{i:2', '{i:11') WHERE `eventid` >= 350

[tito]

thanks....