Update records in PhpMyAdmin

[mrtblt]

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]

select your database and then click on the sql tab and use this query:

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