Click to See Complete Forum and Search --> : Update records in PhpMyAdmin


mrtblt
05-14-2008, 09:54 AM
On my table there is a field named web and in this field links of web sites is recorded. But my problem is this : all the links starts with www. but i want to add http:// at start of each record. How i can do it by using phpmyadmin

aj_nsc
05-14-2008, 10:05 AM
select your database and then click on the sql tab and use this query:

UPDATE `table` SET fieldName = CONCAT('http://',fieldName)