Обсуждение: evaluating subselect for each row

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_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice

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.