Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Can I make a global change in a category easily?

Quote Reply
Can I make a global change in a category easily?
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?

Quote Reply
Re: Can I make a global change in a category easily? In reply to
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/

Quote Reply
Re: Can I make a global change in a category easily? In reply to
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.

Quote Reply
Re: Can I make a global change in a category easily? In reply to
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/

Quote Reply
Re: Can I make a global change in a category easily? In reply to
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

Quote Reply
Re: Can I make a global change in a category easily? In reply to
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?

Quote Reply
Re: Can I make a global change in a category easily? In reply to
SQL Monitor!

Regards,

Eliot Lee
Quote Reply
Re: Can I make a global change in a category easily? In reply to
Whoops my mistake.
Hands moving quicker than eye Wink

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