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.
Concat a string with a field
Moderator: General Moderators