[imp] SQL Help required - if possible

[Jan Schneider]

Zitat von Nigel Cass <N.Cass@Hull.ac.uk>:

> Is there a reasonably easy way of doing the following (pseudo SQL)
> 
> UPDATE horde_prefs SET pref_uid = (part before @) WHERE pref_uid = (
> "part before @"@realmname notneeded anymore)

Sure, but the exact syntax is probably dependant on your actual DBMS.

Jan.

--
http://www.horde.org - The Horde Project
http://www.ammma.de - discover your knowledge
http://www.tip4all.de - Deine private Tippgemeinschaft