Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Validate & Unvalidate All Links

Quote Reply
Validate & Unvalidate All Links
I was wondering if anyone knew what 2 different MySQL code should I type in MySQL monitor in GLinks (3.1.0) so that:
  1. All links (little over 10k) within the directory will be validated. (They all remain in their category and no other changes, just validate changed to Yes)
  2. All Links within the directory will be unvalidated. (They all remain in their category and no other changes, just validate changed to No)

Thank you for the help.

Vishal
-------------------------------------------------------
Quote Reply
Re: [SWDevil.Com] Validate & Unvalidate All Links In reply to
Code:
UPDATE Links SET isValidated = "Yes" WHERE isValidated = "No"


That should do it...

- Jonathan
Quote Reply
Re: [jdgamble] Validate & Unvalidate All Links In reply to
Hi Jonathan,

Based on my understanding, below quote will 'Validate' all the links within the directory.
Quote:
UPDATE Links SET isValidated = "Yes" WHERE isValidated = "No"


& below will un-validated all the links within the directory.
Quote:
UPDATE Links SET isValidated = "No" WHERE isValidated = "Yes"


Thank you very much for the help.

Vishal
-------------------------------------------------------