Intriguing, I asked on the Drupal support list what would be the best way to do this before going down the SQL path and didn't receive this suggestion. One member of the list did end up writing a module, all of all things, that did the same task as the one line of SQL...
no subject