Hi all,
I have a table with a field full of urls.. what I need to do is to append to those urls with a new url, so for example, if the field had http://www.yahoo.com i want to make it http://www.myserver.com/login?url=http://www.yahoo.com .. I have tried the following which I thought should work:- update table set field = concat("http://www.myserver.com/login?url=";, field) where restriction="D" and location="local"; It goes all fine, however when I do a search I have records that now show the url as http://www.myserver.com/login?url=http: and it chops off the rest.. I have checked the size of the field itself and it was a varchar(255).. I thought maybe it was the restriction, which it was for about 51 of them cause they showed up as warnings when I ran the update command, so I changed the varchar to a blob to see the difference and no longer are there any warnings, but it still chops off everything after http: Any ideas? sql --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
