Page 1 of 1

Concat a string with a field

Posted: Thu Oct 06, 2005 11:27 am
by ljCharlie
Currently in the Website column, I have http://www.mysite.com and I want to add http:// infront of the http://www.mysite.com. Here's what I did under phpMyAdmin interface.

UDPATE emaildir SET Website = CONCAT("http://", Website) WHERE Website <> "" //still not working
UDPATE emaildir SET Website ="http://" && Website WHERE Website <> "" //still not working

So any help will be appreciated.

Posted: Thu Oct 06, 2005 11:40 am
by feyd
spelling UPDATE correctly is the first step :P

The first should be fine it appears..

Posted: Thu Oct 06, 2005 1:48 pm
by ljCharlie
Thank you very much! I guess a fresh set of eyes would help.

Again, thanks!