THE SHORT: I am looking for the sql query I need to run in order to change the status of an entry. Any help would be appreciated.
THE LONG: I have two sperate channels and they are NOT linked via a relationship field, however if the status of an entry in Channel A is closed and a field in Channel A matches a field in Channel B I need to update the status of the entry in Channel B. I plan on running this via a cron to automatically update these entries and I dont want to require my users manually change the entries.
Thanks.