If your datbase prefix is lsql_, then you could use the following command in SQL Monitor to set the value for isValidated to No for all of the links in a specific category (category identified by its ID number):
Update lsql_Links, lsql_CatLinks
set lsql_Links.isValidated = 'No'
where lsql_Links.ID = lsql_CatLinks.LinkID
and lsql_CatLinks.CategoryID= Put the Category ID Number Here
BUT to be safe I would first create a test field in the Links Database (something like Validate_Test), and then run the above command using Validate_Test instead of isValidated. Then if those links that have the value of No for Validate_Test are the ones you actually want unvalidated, then you can do the above command with the actual isValidated value.
--FrankM
Update lsql_Links, lsql_CatLinks
set lsql_Links.isValidated = 'No'
where lsql_Links.ID = lsql_CatLinks.LinkID
and lsql_CatLinks.CategoryID= Put the Category ID Number Here
BUT to be safe I would first create a test field in the Links Database (something like Validate_Test), and then run the above command using Validate_Test instead of isValidated. Then if those links that have the value of No for Validate_Test are the ones you actually want unvalidated, then you can do the above command with the actual isValidated value.
--FrankM