[turba] Need to rename/change "owner_id" values

[Chuck Hagenbuch]

Quoting "Michael C. Ibarra" <ibarra at hawk.com>:

> I've recently made a bunch of entries while having realm set. I am no
> longer using realm and I have a bunch of entries in my mysql database
> where owner_id=user at .  I would like to change these entries to just
> user.  I was RTFM'ing the MySql manual and couldn't figure it out.
> It's getting late for me. Perhaps someone can help me here?

UPDATE turba_objects SET owner_id = REPLACE(owner_id, '@realm.com', '');

should do it.

-chuck

-- 
"But she goes not abroad in search of monsters to destroy." - John 
Quincy Adams