Dnia 2008-08-16, sob o godzinie 13:01 -0400, Christopher Friedt pisze:
> update Tracks set Uri = "file:///home/cfriedt/Music" ||
> substr(Uri,length("file:///media/IcyBox/media/audio/mp3")+1,9999) where
> Uri like "file:///media/IcyBox/media/audio/mp3%";
Wow that's some twisted sql ;]
UPDATE Tracks SET Uri = REPLACE("media/IcyBox/media/audio/mp3",
"home/cfriedt/Music", Uri) WHERE Uri LIKE
"file:///media/IcyBox/media/audio/mp3%";
Isn't that more obvious?
--
Michal Sawicz <michal sawicz net>
Attachment:
signature.asc
Description: To jest =?UTF-8?Q?cz=C4=99=C5=9B=C4=87?= =?UTF-8?Q?_wiadomo=C5=9Bci?= podpisana cyfrowo