I have thousands of offline links in my posts, and I'd like to set them all to draft. I know the links are in the format example.com/fileX. So I needed a SQL query to search the post content and whatever post that contain that url will be set to draft.
I think this might be a good start:
UPDATE tb_posts SET post_status = 'draft' WHERE
But I don't know to do the search inside the WHERE clause. I intend to use ARI Adminer Plugin to edit the database.