Point 1 - yes you have to name individual tables, it might be usefull sometimes of you could name the database and all tables in!
Point 2.
I think you might have 1 of two situations such as:
table1.url
which would have values like "
This should be easy enough to update using the syntax I showed you above.
The second situation might be:
tabl2.address
which might have values like:
"customer is
&
"send to
To write an SQL statment to update table2 would mean something like
update table2 set address = left(upto the start of old) + newurl + "right(from end of old) to the end
where address like "%old%"
Now I suspect that your SQL is not massive so you have the options of having a play to get it to work (and we can help with that) or as lggarner suggests dump the DB, update using a text editior and then reload the data.
You decision will probabbly be around the size of the database, do you have the admin skills to unload and reload and if you have the confidence to do it.
I think the people here will be more than helpfull whatever route you take.