On Jun 3, 2012, at 10:55 AM, Scott Ribe wrote:
> As part of anonymizing some data, I want to do something like:
>
> update foo set bar = (select bar2 from fakes order by random() limit 1);
it may or may not be an option, but "update foo set bar=md5(bar)" is a pretty
simple way to redact data.
-
As part of anonymizing some data, I want to do something like:
update foo set bar = (select bar2 from fakes order by random() limit 1);
But of course, that sets them all to the same value, whereas I want them all
different.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/