I have the latest version of Links SQL. I need to change all the links in a category. Is there any easy way to change all the links globally? Now I am doing it one by one in Admin-browse-edit-modify. We use the same URL for that category. I know nothing about MySQL. Any advice?

It would be useful if you told us what you were trying to change.


Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/

Hi, I am trying to change all the URLs in each link in my catergory. All the links in this category use the same URL and I need to change all of them to another URL. Now I go to Admin and browse. I will go to each link and edit them one by one. As I have hundreds of links, it is ver time consuming and repeatitive. Do you know a way that I can make a global change and all my URL will change at once to a new URL? Thanks.

Don't quote me on this but......

UPDATE Links SET URL = 'OLD_URL_HERE' WHERE URL = 'NEW_URL_HERE';



Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/

Paul:

I think Old_URL_Here and New_URL_Here should be switched...

SO....

Try: Update Category set FEILD = 'New_URL_Here' where FIELD = 'Old_URL_Here'

This is assuming the Table is Category.... if the field is in Links, change Category to Links

dave

Hi, Thank you for your help. I know nothing about MySQL. So when you say update old url and new url, where do you do that? Is this some kind of MySQL language? Or is it done in Admin?

SQL Monitor!

Regards,

Eliot Lee

Whoops my mistake.
Hands moving quicker than eye

Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/