Use a SQL UPDATE statement to add "http://www."; to all the rows where
that column doesn't start with "http://www.";. The syntax would be
something like the following:
UPDATE mytable SET mycolumn = CONCAT("http://www.",mycolumn) WHERE
left(mycolumn,11) != "http://www.";
Best regards,
Jim Mullen
Visit http://www.iDimensionz.com for professional web site programming
and affordable web site hosting.
--- In php_mysql@yahoogroups.com, Tedit kap <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I am trying to modify the values I entered before into a mysql table
column where I had entered links only. They were links however they did
not have http://www. in the beginning (I was taking care of the proper
display in php display file).
>
> From now, I want to enter links properly, so I changed the php file,
without automatically adding/writing http://www. in the beginning, but
this time the old values links dont work.
>
> How can I add http://www. to the beginning of all vaules in this
column?
>
> Thanks
>
>
>
>
> [Non-text portions of this message have been removed]
>
