I'd like to update a set of records where the column name='picture' where id>='1'.
id is the primary key, auto increment field.
The picture field has values like:
But I'd like like to prepend the url with:
so the picture field values should be:
How do I do this with one mysql statement?