Currently I'm doing a mysql query via the command line using Drush and I want to parse the query output and grab the Node ID #, then put that ID # into a
drush php-cli 'node_delete(X)' command. How can I do this? Currently I have the command:
drush sql-query 'select * from node where type="feed_item" AND status=0 limit 1 \G'
drush php-eval 'node_delete(X)'
I think I'm suppose to use the command xargs?
From there how can I make this as a loop and delete everything that get's outputted? Yes I know I can just do it via the site, but i want to know how to do it via the command line using only Drush. Eventually I just want to make an interactive bash script where I can just put in the node ID range numbers and it will just delete it at once.