Re: Need to rename/change "owner_id" values

Quoting "Michael C. Ibarra" <ibarra@xxxxxxxx>:

> 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@.  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
--
Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: turba-unsubscribe@xxxxxxxxxxxxxxx